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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows based on contents of Col A 0
Excel VBA 1
index function in vba 3
VBA set thick borders around non empty cells in range 0
Check if Excel workbook is open via Word VBA, if open how to close it? 0
How to Select A Cell in VBA with a Variable Row Number? 3
Help With MS Access 4
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top