Text box value to userform

  • Thread starter Thread starter Do
  • Start date Start date
D

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
 
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'`
Click to expand...

Try this line of code...

Me.ComboBox1.AddItem Worksheets("Sheet6").Shapes("Text Box
13").OLEFormat.Object.Text
 
Rick Rothstein said:
Try this line of code...

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

Thx Rick - works perfect ;o)

Do/
 
Back
Top