text box

[ekkeindoha]

How do I get data that I enter in the "text box" to show in collumn A1

 

[Toppers]

Which "text box" - how is it created => Forms or Control Toolbar?

 

[Mike]

You could use this in the Click event of the userform
Const columnA1 = "A1"
Range(columnA).Value = Me.Textbox1.Text

 

[Mike]

opps try this
Const columnA1 = "A1"
Range(columnA1).Value = Me.Textbox1.Text