Excel combobox question

[jdw]

I have a worksheet (which is created from a template) which has
several comboboxes on it, and when you open the boxes there is data.
However, I do not see any code behind it - I right click on it and I
get what looks like regular choices e.g. copy,paste. They are all
named ranges. Do anyone have any idea what these are and how to get
access to the data and/or the code?

Thanks.

 

[Dave Peterson]

It sounds it was created using Data|Validation.

If you click on the cell and the use Data|validation, does it look like that
dialog is filled out?

If yes, then here's a link to Debra Dalgleish course:
http://www.contextures.com/xlDataVal01.html