Excel 2007 : Cell that turns into a droplist?

[BigGPL]

Howdy,

Can someone tell me how when one clicks on the blue cell, in the attached file, it turns into an activex combobox, and when you click on a different cell the combox disappears?

I had this tucked away on my old computer, and I must have not transfered the other files to my new system. I can't find any code or properties for this.


Thanks in advance.

[martindwilson]

looks like data validation to me
refering to a list called invlist

[davesexcel]

The cell is a dropdown from data validation, not an activex combobox.

Click the data ribbon, select data validation, you will see the range used to create the list.

[MarvinP]

To see where the named range of "InvList" is you need to click on the Formulas Tab and then Name Manager. It looks like InvList is a dynamically named range using the =Offset type format. Read:
http://www.exceluser.com/explore/dynname1.htm

[BigGPL]

Hey Guys,

Thanks for the info.

Just learned something new.