Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DEclaring variables
I am declaring it in the standard module
"Chip Pearson" wrote in message ... Pedro, Are you declaring the variable in a standard code module, rather than a sheet's code module or a form or ThisWorkbook? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... Hi I have declares as a Public variable strNumber doing: Public strNumber as variant when the code opens runs other module in a different worksheet the variable is empty how to solve it? thanks Pedro ps. Chip thanks for all your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DEclaring variables
Pedro,
The only thing I can think of is that the variable is misspelled. Do you have "Option Explicit" at the top of all your code modules? You should, since the will require that all variable be explicitly declared, and misspelled variables will be flagged by the compiler. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... I am declaring it in the standard module "Chip Pearson" wrote in message ... Pedro, Are you declaring the variable in a standard code module, rather than a sheet's code module or a form or ThisWorkbook? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... Hi I have declares as a Public variable strNumber doing: Public strNumber as variant when the code opens runs other module in a different worksheet the variable is empty how to solve it? thanks Pedro ps. Chip thanks for all your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring variables | Excel Discussion (Misc queries) | |||
DEclaring variables | Excel Programming | |||
Declaring Variables | Excel Programming | |||
Declaring Global Variables | Excel Programming |