text box to variable
 

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.

text box to variable
 

Dim S as String
S = Textbox1.Text

HTH. Best wishes Harald

"BOONER" skrev i melding
...
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.

text box to variable
 

Thanks a lot Harald.

"Harald Staff" wrote:

Dim S as String
S = Textbox1.Text

HTH. Best wishes Harald

"BOONER" skrev i melding
...
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.

text box to variable
 

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.

text box to variable
 

I am getting runtime error 424
Object required

"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.

text box to variable
 

My wife took our crystal ball with her. I'll have to wait for her to return
home, unless you choose to show me your code yourself.

Best wishes Harald

"BOONER" skrev i melding
...
I am getting runtime error 424
Object required

text box to variable
 

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.