Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring data entered into a Text box to another Cell/Sheet?
Is it possible to record a macro that allows you transfer the data that
is entered into a text box to another cell/sheet? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring data entered into a Text box to another Cell/Sheet?
You can't really record a macro that does this.
Private Sub Textbox1_Change() Worksheets("Sheet1").Range("A1").Value = textbox1.Text End sub This uses the change event for the textbox. There may be better events to use depending on what you want to do. Change is common to both a textbox on the worksheet and in a userform. This assumes and MSforms.TextBox -- regards, Tom Ogilvy Alan T wrote in message ... Is it possible to record a macro that allows you transfer the data that is entered into a text box to another cell/sheet? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring Data from one sheet to another | Excel Discussion (Misc queries) | |||
Transferring a cell value to another sheet | Setting up and Configuration of Excel | |||
Transferring data from one sheet to another if criteria are met. | Excel Worksheet Functions | |||
Can a cell be linked to read data entered into a text box ? | Excel Discussion (Misc queries) | |||
Can a cell be linked to read data entered into a text box ? | Excel Discussion (Misc queries) |