| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
| Entering Variable Text in Text Boxes...... | Excel Discussion (Misc queries) | |||
| Put variable into text ? | Excel Programming | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| check variable(text) with cell (text), textbox | Excel Programming | |||
Hybrid Mode
