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)

"Eric" wrote in message
...
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?