98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Compare Text
Option Compare Text
Resolved · Low Priority · Version 2003
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?
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |
