Thread: Text box value to userform
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)

Reply With QuoteReply With Quote