![]() |
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 |
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 |
All times are GMT +1. The time now is 01:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com