Get the value from drop down

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?
 
B

Bob Phillips

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)
 
G

Guest

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
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
Drop Down Box 7
Some trouble assigning a string to a variable 22
Choosing a drop-down menu selection returns value to another cell 2
Drop Down with hidden values 1
EXCEL DROP DOWN 2

Top