input box

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Input box

Input box

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.09 secs.