prompting user for information 1

[Luis939]

How do i create a dialogue box or something, to ask the user for a number, and store that number to use in the macro, ive never done anything where i get data from the user or anything like that, thanks

 

[bryanbayfield]

variablename = InputBox(PromptString)

The above is the simple way to do it - the response is then stored in whatever you've called

variablename

. If you're looking for something more sophisticated, use the Application object.

variablename = InputBox(Prompt, Title, Default, Left, Top, HelpFile, HelpContextId, Type)

You can then restrict the user to certain types of variable (eg string, date etc) by specifying a code for

type

.

Look in teh help file for more details.

 

[Luis939]

thanks alot!

 

[bryanbayfield]

No worries chief.

That kind of stuff is very easy to pick up if you've got a decent VBA book. You'd be amazed at how proficient you can get in a short space of time.

If you need a recommendation, just let us know.

 

[Luis939]

sure, what do u recommend as a good vba book for starters and intermediate

 

[YNOTU]

http://www.exceltip.com/book-1931841047.html

http://tutorials.beginners.co.uk/book/id/247

http://www.exceltip.com/bc-Microsoft_Excel_books_for_Beginners,3

[tt]

​

 

[Chattin]

More book stuff here:

http://www.mrexcel.com/book.shtml

http://j-walk.com/ss/books/buybooks.htm

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help