Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Compare Text

	98.1 % recommend us
	More live stats...

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

Training information:

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

Option Compare Text

Resolved · Low Priority · Version 2003

Reply Fri 16 May 2008, 16:45Delegate James said...

James has attended:
Excel VBA Intro Intermediate course

Option Compare Text

Can an Option be used with in an individual sub?

For upcoming training course dates see: Pricing & availability

Reply Tue 3 Jun 2008, 14:56Trainer Carlos said...

RE: Option Compare Text

James

The simple answer is NO

All Option Statements must appear at module level BEFORE any Procedures

Within a Workbook each Module can hold its own Option Statements that will be activated when the code in the Module is run

Hope this helps

Carlos

Excel articles

· Finding Your Way Around Excel 2007
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· The Best Way To Use Clip Art Images In Excel
· Never Lose It In Translation With Excel
· How To Make Excel Open A Particular File When It Launches

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

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips