selecting range as input in VBA

  • Thread starter Thread starter moshe_xls
  • Start date Start date
M

moshe_xls

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
 
Hi,

Do you mean this

Set myrange = Application.InputBox(Prompt:="Please select range", _
Title:="Range Selector", Type:=8)

MsgBox "You selected " & myrange.Address

Mike
 
Back
Top