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" <(E-Mail Removed)> wrote in message
news:31CAE28F-0A15-48BE-BD2C-(E-Mail Removed)...
> 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
>