problems with a userform
Tank you , could you chek the disscution about :
"problems with a formulas" 3 lines at bottom from this one
Tanks
"David Hepner" wrote:
Declare a & b as public variables at the top of your code (before Private Sub
CommandButton1_Click)
Public a As String
Public b As String
"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
|