Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Soe Soe is offline
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to use text typed in a cell C27 in formula Ex:Vlookup(C27.. excel help Excel Worksheet Functions 2 October 8th 09 06:11 PM
# symbol appearing instead of typed text in a cell ESG67 Excel Discussion (Misc queries) 1 March 12th 09 04:06 PM
Typed or pasted text in a cell appears as #### susanhasquestion Excel Discussion (Misc queries) 6 September 19th 07 01:50 AM
use value in texbox to search through worksheet GEORGIA Excel Discussion (Misc queries) 0 March 29th 05 08:15 PM
Excel merged cell - can it automatically expand as text is typed? Joanne (JAS) New Users to Excel 2 January 8th 05 12:11 AM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"