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

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