View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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)