VBA

Resolved · Low Priority · Version 2003

VBA

Alix has attended:
Excel VBA course

by - delegate Alix [4 posts] (2008 Aug 14 Thu, 16:56) Reply

What is option explicit?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

VBA - Option Explicit

by - trainer Carlos gold contributer [473 posts] (2008 Aug 26 Tue, 09:32) Reply

Hi Alix

Option Explicit forces the user to make explicit declaration of all variables in a file using the Dim or ReDim statements.

If you attempt to use an undeclared variable name, an error occurs at compile time.

If used, the Option Explicit statement must appear in a the code before any other code statements.

Use Option Explicit to avoid incorrectly typing the name of an existing variable or to avoid confusion in code where the scope of the variable is not clear.

If you do not use the Option Explicit statement, all undeclared variables are of Object type.

Hope this helps

Carlos

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· From the Classroom to the Corporate World
· Creating Charts with Excel
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips