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
 
Back
Top