| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box value to userform
Hi
In my sheet i have a text box. Whats the VBA code for loading the Text Box 13 value into combobox1 on a userform on 'initialize'` /Do |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box value to userform
In my sheet i have a text box. Whats the VBA code for loading the
Text Box 13 value into combobox1 on a userform on 'initialize'` Try this line of code... Me.ComboBox1.AddItem Worksheets("Sheet6").Shapes("Text Box 13").OLEFormat.Object.Text -- Rick Rothstein (MVP - Excel) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box value to userform
"Rick Rothstein" skrev i en meddelelse
... In my sheet i have a text box. Whats the VBA code for loading the Text Box 13 value into combobox1 on a userform on 'initialize'` Try this line of code... Me.ComboBox1.AddItem Worksheets("Sheet6").Shapes("Text Box 13").OLEFormat.Object.Text -- Rick Rothstein (MVP - Excel) Thx Rick - works perfect ;o) Do/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm Text Box to display worksheet cell text | Excel Programming | |||
| Drag and drop text in userform text / combo boxes | Excel Programming | |||
| Userform Text Box | Excel Programming | |||
| Highlight certail text in a userform Text box | Excel Programming | |||
| Userform text box | Excel Programming | |||
Linear Mode
