Referencing drop down menu in worksheet

[chungtinhlak]

How do you reference a combobox that's added to your worksheet from the form toolbox. ?

thanks

[Bob Phillips]

It has a worksheet event associated with. Go into design mode and double-click the combo.

[chungtinhlak]

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