A macro that Asks a user to select a range in excel?

M

Ming Ma

Hi, all:
How can I write A macro that Asks a user to select a range in excel? so I
can use the values in the selection for calculation later on.

Thanks
 
T

Tushar Mehta

In XL VBA help, look up the Application object's InputBox method. In
using it, specify the Type argument as 8 (Range object).

Note that VBA also supports an InputBox function, which is *not* what
you should use.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Macro to select and delete levels of a document 2
Macro to Select text from a point given to a specific word 2
Need Help with Macro Security 1
Range headings 0
Word macro that can call cells out of Excel for a find and replace 0
Select Text to End of Footnote 9
Drop down list control value in vba 2
AppleScript - How do I select a text ? 1

Top