| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DEclaring variables
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,
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Declaring variables for use in multiple worksheets | Excel Discussion (Misc queries) | |||
| Declaring variables | Excel Discussion (Misc queries) | |||
| Declaring variables | Excel Discussion (Misc queries) | |||
| Declaring Variables | Excel Programming | |||
| Declaring Global Variables | Excel Programming | |||
Linear Mode
