Diane has attended:
Excel VBA Intro Intermediate course
Input box
How do you create an input box?
RE: input box
Hi Diane
Thank you for your question
You use an input box to allow the user to set the value of a variable in your code.
The syntax is as follows
Myvariable = Inputbox("Enter a number")
The inpurt box function also has arguments for caption, positioning etc. I suggest typing the word InputBox into your VBE, selecting it and pressing F1. This will launch the context driven help feature and will provide you with a detailed description of all the arguments
Regards
Stephen