How do you reference a combobox that's added to your worksheet from the form toolbox. ?
thanks
How do you reference a combobox that's added to your worksheet from the form toolbox. ?
thanks
It has a worksheet event associated with. Go into design mode and double-click the combo.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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