| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox form to Textbox in worksheet
I want the text typed in by a user in a textbox on a userform to be transferred to a textbox in the worksheet. Capturing the typed text is easy : Textbox.Value Creating a textbox on the sheegt a bit more complex : ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextB ox.1", Link:=False, DisplayAsIcon:=False, Left:=528.75, Top:=204, Width:=432, Height:=77.25).Select But how do I get the Textbox.Value into the new created textbox? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pass to textbox on a form and to excel worksheet | New Users to Excel | |||
| Userform Textbox to Worksheet Textbox | Excel Programming | |||
| Textbox from 1st worksheet to textbox to other multiple sheets | Excel Programming | |||
| put worksheet values into textbox on form | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Threaded Mode
