Text Box

F

Fable

Greetings,

I got a userform with a text box that I would like what ever is writte
in dump that info into Sheet1 A1.

Any help is appreciated
 
C

Celtic_Avenger

in VBA

In the properties section of Visual Basic. Select the text box, an
name it something. in this I call it:

txtbox1

Then use another button in the User form called something like Submit.

Rename the button to again something you will recognise.
in this I call it:

SubmitButton1

then use similar formula as follows


Sub SubmitButton1_Click()

ActiveWorkbook.Sheets("sheet1").Range("A1")=textbox1.value

end su
 
Top