Then enter the code suggested by Harald in the same macro that is triggered
by clicking on the button... provided that macro belongs to the form. If it
doesn't, then prefix TextBox1 by UserForm1. (with the dot) (Userform1 is the
name of your form).
--
Stefano Gatto


"BOONER" wrote:

What if the text box is in a userform and the variable that needs to be
assigned to the value of the text box is in a macro that is started after a
button click from a button on the same userform as the text box? I hope that
makes sense.

"BOONER" wrote:

I know this is probably simple, but I need to asign the text input into a
text box to a variable after a button click.