Passing a variable from a UserForm to a Procedure

[Herve]

Hello All!

I do not succeed to pass a variable (Control Button) from a UserForm to a Procedure (in a regular Module).

I am declaring the variable as Public and Static, but I get a message that VBA does not support this kind of automation.

What's the best way to do that? (I currently save the variable in a cell on a worksheet before unloading the UserForm, then read it from that location when I am back in the Procedure. I figure there must be an easier way

Thanks!

 

[Juan Pablo González]

and, you don't have to worry about the program making a compile in the background, which can destroy the value of the public variables !

 

[pint]

Herve -

I use invisible text boxes and check boxes all the time. Very handy and very sneaky.

- Jon

And very pointless. Variables does the same.

 

[Jon Peltier]

But you need to set up public variables.

A chacun son gout.

 

[Herve]

Well, as Jon says, or at least means , to each his own.

I think however the question is which one is more efficient.

Isn't a Public variable, once declared, reserved in memory whether used or not? Since the TextBox is deleted once the UserForm is closed, aren't we ahead of the game?

 

[Danielone]

Hi,
I would be more than happy if you could help me.

I have to run a macro where, at a certain point, I ask the user to set the variables "capital" and "time".
Here the code for the Userform:

Private Sub CommandButton1_Click()

capital = UserForm1.TextBox1.Value
temp = UserForm1.TextBox2.Value

Me.Hide

End Sub


In the main code of the macro I have just written:

UserForm1.Show

But is not working. VBA can't read the variables' values, so the routine does not work.
I really do not know what to do.
I am stuck on this stupid thing and cannot go ahead.
If you could help me I would be pleased.
Thank you!
D