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 » training access vba london - Nothing

	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

training access vba london - Nothing

Resolved · Low Priority · Version Standard

ReplyTue 2 Oct 2007, 09:41Delegate Rachel said...

Nothing

This is a test question, so I can register.

Rachel

For upcoming training course dates see: Pricing & availability

ReplyTue 2 Oct 2007, 11:01Trainer Rich said...

RE: Nothing

Thanks Rachel.

Hope you enjoyed your Excel VBA training yesterday.

I hope you get a lot of use out of this forum.

I'll mark this question as resolved.

Regards, Rich

VBA articles

· How To Use VBA To Create A Data Entry Box In Excel
· What Are Modules In Excel VBA Coding?
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· An Introduction To The Excel VBA Editor Screen
· If It's Not Broken Why Should You Fix It? Find Out With VBA

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips

I want to create a drop down list in Cell A1 containing say these references DR1 DR2 DR3 DR4 etc, and in cell B1 I wish to show a prepared description of the item when selected,
so when I select DR1 it shows a description and when DR2 is selected it chan..

» Forum post: Drop down lists

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