Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with a userform
Hi,
1. Where/How are a and b declared (which module; outside of any procedure or whitin a procedure). 2. From the online help about the 'End' statement: "When executed, the End statement resets all module-level variables and all static local variables in all modules. " 3."variables that save his value in all the program :" Declare it as Public in a general code module. However, you have to be aware that while codinng the application, going in the VBE and editing the code may reset variables. Therefore sometimes, you run the application, the variables are set, but you want to change the code so you go in the VB Editior which resets these variables. 4. "variables that save his value althougt the program is close and open again" You can write them to a file (see help topic Writing Data To FIles; the Open/Close/Get/Write/Put statements), to the registry if you want to save application level data such as options, or if your application processes xl files, you could save the variables in these books. -- Regards, Sébastien <http://www.ondemandanalysis.com "filo666" wrote: Hi, I have a userform with 2 textboxes: Private Sub CommandButton1_Click() a=textbox1 b=textbox2 macro1 'execute the macro1 end end sub sub Macro1() msgbox a,vbokonly,b end sub my problem is that when the userform lost focus the variables lost their value, I mean, when macro1 is called a and b appears as a=empty and b=empty and I want the values od textbox1 and textbox2 How to savfe the variables so they are available using the macro1 ??? Aldo I would like to know information about deffining variables that save his value in all the program and also variables that save his value althougt the program is close and open again TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform problems | Excel Programming | |||
userform problems | Excel Programming | |||
userform problems | Excel Programming | |||
UserForm Problems | Excel Programming | |||
More UserForm problems | Excel Programming |