PDA

View Full Version : VBA


anandbw82
09-22-2009, 07:56 AM
Hi,

How to get "option explicit" in the code window. whenever i double click on the sheet1 i get bland code window, not with "option explicit". i am using excel 2003.

Any suggestion...?
Bob Phillips
09-22-2009, 07:58 AM
In the VBIDE, goto Tools>Options>Editor and check the 'Require Variable Declaration' box.
mdmackillop
09-22-2009, 08:00 AM
In the VBE
Tools/Options/Editor - Require Variable Declaration
anandbw82
09-22-2009, 08:02 AM
In the VBIDE, goto Tools>Options>Editor and check the 'Require Variable Declaration' box.

thank u very much..