Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to use text typed in a cell C27 in formula Ex:Vlookup(C27.. | Excel Worksheet Functions | |||
# symbol appearing instead of typed text in a cell | Excel Discussion (Misc queries) | |||
Typed or pasted text in a cell appears as #### | Excel Discussion (Misc queries) | |||
use value in texbox to search through worksheet | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |