Text box value to userform

[Do]

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

 

[Rick Rothstein]

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

 

[Do]

Try this line of code...

Me.ComboBox1.AddItem Worksheets("Sheet6").Shapes("Text Box
13").OLEFormat.Object.Text

Thx Rick - works perfect ;o)

Do/