Excel combobox question

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
Tue Aug 17 16:59:04 CDT 2004

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

jdw wrote:
>
> 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
ec35720@msn.com