The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » Vba

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Vba

Resolved · High Priority · Version 2003

ReplyTue 1 Apr 2008, 16:28Delegate Tatiana said...

Vba

what is the inputbox function

For upcoming training course dates see: Pricing & availability

ReplyTue 8 Apr 2008, 16:06Trainer Carlos said...

The Inputbox Function

Hi Tatiana

To allow the user to enter text or numbers into the system we can use the InputBox Function.

The syntax for the InputBox Function is;

InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

prompt = the question being asked

[,title] = The tytle of the inputbox

[,default] = A default value

It is rare that you will need to use:

[, xpos][, ypos] = The position of the inputbox on the screen

[, helpfile, context] = The help information

Hope this helps

Carlos

VBA articles

· What Are Modules In Excel VBA Coding?
· Make Office work for you with VBA
· VBA - What Is It, And Should You Learn It?
· Starting Out With Excel 2007 VBA Using The Macro Recorder
· Tips On Getting VBA Bugs To Bug-off

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

Vba tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips

Is it possible to insert buttons on forms that will bring up all information/records related to a particular ID?

» Forum post: Buttons

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions