ExcelBanter - text box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - text box (https://www.excelbanter.com/excel-discussion-misc-queries/149306-text-box.html)

ekkeindoha

text box

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

Toppers

text box

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

"ekkeindoha" wrote:

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

Mike

text box

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

"ekkeindoha" wrote:

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

Mike

text box

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

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

"ekkeindoha" wrote:

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

All times are GMT +1. The time now is 05:47 PM.