Greg,

If it is a control dropdown, it is the ListIndex property.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"greg" wrote in message
...
hello

just a quick question.

How do you return the value of a dropdown form in a sheet?

I'm trying to set up my own print option on a workbook.
The way I would like it to work is by checking each of
the 160 sheets for the value of a dropdown. if it is one
of 5 options it will select it, then check the rest and
so on. My only problem is that I need to find out what
has been chosen on each sheets dropdown and nothing seems
to work.

TIA
greg