Search found 4 matches
- 10 Sep 2022, 06:41
- Forum: Ask for Help (v1)
- Topic: Get range from VBA InputBox Topic is solved
- Replies: 2
- Views: 287
Re: Get range from VBA InputBox Topic is solved
It works, thank you so much.
- 09 Sep 2022, 08:22
- Forum: Ask for Help (v1)
- Topic: Get range from VBA InputBox Topic is solved
- Replies: 2
- Views: 287
Get range from VBA InputBox Topic is solved
Hi, i'm trying to select a range from an Excel InputBox. I managed to call the inputbox but i can't get the range selected with it. Here's my code: ^Numpad9:: oxl := ComObjActive("Excel.Application") RangeSelection := oxl.Application.InputBox("Seleziona cella col nome foglio", "Valore indiretto") Ms...
- 09 Sep 2021, 05:22
- Forum: Scripts and Functions (v1)
- Topic: Excel: get selection screen coordinates (selected cells)
- Replies: 3
- Views: 1680
Re: Excel: get selection screen coordinates (selected cells)
I found a solution to my problem, in case anyone needs it. I just changed lines 11 and 12 to:
Code: Select all
vWinX := oXl.ActiveWindow.ActivePane.PointsToScreenPixelsX(0)
vWinY := oXl.ActiveWindow.ActivePane.PointsToScreenPixelsY(0)
- 06 Jul 2021, 04:24
- Forum: Scripts and Functions (v1)
- Topic: Excel: get selection screen coordinates (selected cells)
- Replies: 3
- Views: 1680
Re: Excel: get selection screen coordinates (selected cells)
Hi jeeswg and thank you for your script.
I have a problem with it: it doesn't work when there are freezed panes or row in the sheet. Is there some kind of workaround?
Thank you again
I have a problem with it: it doesn't work when there are freezed panes or row in the sheet. Is there some kind of workaround?
Thank you again