| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Explicit
Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Explicit
Try this, fish:
http://www.vbaexpress.com/forum/arti...ticle&artid=40 ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Piranha" wrote in message ... Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Explicit
Hi, I don't know how to quote the entire thread so i picked on Anne. Anne-yes fish :) (at work i am (first -Ima, last Fish,--"Ima Fish") Dave Bob Chip You guys are wonderfull. Thx for the great info and links. Now i am trying to soak it up into my brain. Thx Very Much for your responces Dave Anne Troy Wrote: Try this, fish: http://www.vbaexpress.com/forum/arti...ticle&artid=40 ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Piranha" wrote in message ... Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Explicit
It forces you to declare every variable you use in that module.
You should use it in every module that you have. When this doesn't work like it should myCtr1 = myCtrl + 1 (one of those has an ELL and one has a ONE) It really makes debugging easier. Piranha wrote: Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Explicit
First, you should ALWAYS use it.
What it does it is to force you to explicitly declare your variables. If you fail to declare them, then you will get a compilation error. The advantage of using it is that you won't then make the mistake of mis-spelling (even slightly) variable names deep in the code, as the compiler will flag it. You can use the VB IDE to help you by automatically installing this line in your modules. To do this, in the VB IDE, go to ToolsOptionsEditor, and check the 'Require Variable Declaration' checkbox. -- HTH RP (remove nothere from the email address if mailing direct) "Piranha" wrote in message ... Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Explicit
See http://www.cpearson.com/excel/variables.htm for details.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Piranha" wrote in message ... Hi, Would someone please explain to me the "Option Explicit" phrase. What does it do? When should you use it? Etc Thx Dave -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=384692 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Explicit | Excel Discussion (Misc queries) | |||
| option explicit | Excel Discussion (Misc queries) | |||
| option explicit error | Excel Programming | |||
| Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
| Option Explicit | Excel Programming | |||
![Piranha[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
