98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Input box
Input box
Resolved · Low Priority · Version 2003
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
Wed 15 Apr 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Copying Formulae QuicklyThere is a quicker way of copying a formula down a column. |