Posting text typed inside a TexBox into the worksheet cell

  • Thread starter Thread starter Syed Ahmad Anas
  • Start date Start date
S

Syed Ahmad Anas

Hi,

Anyone knows how to put text typed inside a TexBox into the worksheet cell.

For example: by entering "my name is" inside textbox1, it will appear in
cell A12.
Please help me
 
reading "help" would benefit you...your request is a
pretty basic use of a textbox control.

There are at least two ways to achieve this. One is to
set the textbox's Contro;Source property to a specific
cell...so any change to the cell or text is copied
automatically, or use code like this:
Range("A1").Value = Textbox1.Text

Patrick Molloy
Microsoft Excel MVP
 
your textbox is in msForm?
if so, just do it as
cells(12,1).value=form1.textbox1.value
if yours is inputbox, then
cells(12,1).value=inputbox("brabrabra")
 
Back
Top