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

input box

ResolvedVersion 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:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.15 secs.