Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting range as input in VBA
Hi,
I'm looking for VBA function (or script) that allows me to select range (with mouse) as input (like the Excel SUM function for example). Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting range as input in VBA
Hi,
Do you mean this Set myrange = Application.InputBox(Prompt:="Please select range", _ Title:="Range Selector", Type:=8) MsgBox "You selected " & myrange.Address Mike "moshe_xls" wrote: Hi, I'm looking for VBA function (or script) that allows me to select range (with mouse) as input (like the Excel SUM function for example). Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting range as input in VBA
Thanks,
This is exactly what I looked for :) "moshe_xls" wrote: Hi, I'm looking for VBA function (or script) that allows me to select range (with mouse) as input (like the Excel SUM function for example). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA selecting an input range of cells | Excel Discussion (Misc queries) | |||
selecting target sheet as an input | Excel Programming | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
selecting cells with an input box | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |