Accessing value of drop-down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Title change with Drop Down Selection 2
EXCEL DROP DOWN 2
Set Column choice to a variable from a Drop Down 4
Populate list or combo box from closed workbook 4
Drop Down List 2
Pick from drop-down list gives empty or erroneous result 6
use ComboBox value to select range and then use selected range tocreate a chart 3
Drop Down Box 1

Back
Top