Get the value from drop down

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

How would I go about getting the value that's in a drop
down box in a Excel worksheet? I want to do some things
based on the value in the drop down box, but I just need
the code to grab the value.

Sheets(x).DropDown1.Value does not work.

Any ideas?
 
Add the cell link via the drop down format and get the value from that cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Make sure your referring to it by its proper VB name: In design mode > Right click>View Code> use the name given to it in code, ie(ComboBox1) then you can use ComboBox1.valu

----- Eric wrote: ----

How would I go about getting the value that's in a drop
down box in a Excel worksheet? I want to do some things
based on the value in the drop down box, but I just need
the code to grab the value

Sheets(x).DropDown1.Value does not work

Any ideas
 

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

Drop down list - link to another worksheet 4
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Drop Down Box 7
VBA HELP: Display values in Dropdown2 based on Dropdown2 selection 2
Drop Down with hidden values 1
Hide rows using VBA based on cell value 0
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2

Back
Top