Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modules and Forms II
Hi,
I have a module that call a form using frmMain.Show the form gets a value for a variable xxx=12 but whenever it turns to the module (by doing frmMain.Hide) the xxx has no value I already declared as a public variable doing "Public strNoM As Variant". What change should I make to the code in order to have the variable. Regards Pedro |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modules and Forms II
Pedro,
I'm not sure what is causing the problem. Do you have the variable strNoM declared in the form's code module in addition to a standard code module? You shouldn't. It should be declared only in the standard code module. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pedro" wrote in message ... Hi, I have a module that call a form using frmMain.Show the form gets a value for a variable xxx=12 but whenever it turns to the module (by doing frmMain.Hide) the xxx has no value I already declared as a public variable doing "Public strNoM As Variant". What change should I make to the code in order to have the variable. Regards Pedro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Modules | Excel Discussion (Misc queries) | |||
Help with modules. | New Users to Excel | |||
Modules and Forms | Excel Programming | |||
Need help on How to programatically Import VBA Project Excel Objects, Forms, Modules | Excel Programming | |||
Class Modules vs Modules | Excel Programming |