Posting text typed inside a TexBox into the worksheet cell
 

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

Posting text typed inside a TexBox into the worksheet cell
 

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
-----Original Message-----
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


.

Posting text typed inside a TexBox into the worksheet cell
 

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")

"Syed Ahmad Anas" wrote in message
...
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