View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
debartsa debartsa is offline
external usenet poster
 
Posts: 18
Default Referencing a ComboBox control from a Workbook Object?

Hi Everybody,

I have a ComboBox control on a Worksheet. From the code behind of the
Worksheet I am able reference it and alter it's properties

i.e. MyComboBox.Text = "Hello"

My goal is to reference that same control from the code behind of the
Workbook instead?

i.e. ThisWorkbook.Worksheets("Sheet1"). ?

Thanks for any help!
Sam

P.S. ThisWorkbook.Worksheets("Sheet1").MyComboBox.Text doesn't work?