PDA

View Full Version : referencing drop down menu in worksheet



chungtinhlak
12-10-2009, 08:31 AM
How do you reference a combobox that's added to your worksheet from the form toolbox. ?

thanks

Bob Phillips
12-10-2009, 09:07 AM
It has a worksheet event associated with. Go into design mode and double-click the combo.

chungtinhlak
12-10-2009, 11:28 AM
I think i stated the question wrong. Inside the workbook, I have a sheet that is a chart. In is chart, I have a combobox and a text box i think vba look at these as shapes. I need to know how to read these in vba so that it can pull up it's current value.

I tried

activesheet.shapes("Drop Down 2").value

but this doesn't work.

thanks