Input Box

  • Thread starter Thread starter Avner Mediouni
  • Start date Start date
A

Avner Mediouni

Dear Sirs,
I would like to build a macro that ask the user to input a range using the
mouse (similar to the standard input to the graph dialog).

Can anybody suggest away to to it?

Sincerely

Avner
 
Use Application.Inputbox, with Type:=8

Set myRange = Application.Inputbox("select a range",Type:=8)
 
You must log in or register to reply here.

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

ComboBox 1
Class module 1
Unable to specify position of InputBox Method Dialog Box on the sc 5
Add to Dynamic Named Range 4
Input/combo box 2
Input box display 2
Input Box Q 3
Using one Input Box Method For Two Separate Macros 2

Back
Top