input box
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Input box

resolvedResolved · Low Priority · Version 2003

replyReply Tue 31 Mar 2009, 16:37Delegate Diane said...

Diane has attended:
Excel VBA Intro Intermediate course

Input box

How do you create an input box?

For upcoming training course dates see: Pricing & availability

replyReply Thu 9 Apr 2009, 08:16Trainer Stephen said...

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.

 

Please browse our web site to find out more about
excel-training-advanced courses and other Microsoft training courses.

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard