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

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)

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/