Hi there,

Seems like a simple request, but no-one here can tell me how!

I have a macro which generates a chart, but it needs to generate this chart
from a selection which the user selects with a drop down.

I.e. Use drop down to select "data1", click on button to generate chart for
"data1".

Only thing is, I can't work out how to access what the drop-down is
currently set at?


Steve

Link the dropdown to a cell, and then test that cell value.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steve" wrote in message
...
Hi there,

Seems like a simple request, but no-one here can tell me how!

I have a macro which generates a chart, but it needs to generate this
chart
from a selection which the user selects with a drop down.

I.e. Use drop down to select "data1", click on button to generate chart
for
"data1".

Only thing is, I can't work out how to access what the drop-down is
currently set at?


Steve