Hi GS,

I appreciate your help. The coding isn't an issue for me. I can
handle the coding side easily. The limitation comes from Excels
inability to use a dynamic named range as an ADO data source,
compounded by the 255 character limit on using VBA to define the
validation list.

To the best of my knowledge there is no direct way to assign either
an ADO recordset as a list source or an array (in memory) to get
around the 255 character limit. This leaves the unenviable problem of
trying to define the list in code and produce a new list for every
dropdown in every column and row. Highly untenable.

Basically using Excel here I would have to put together a very
awkward and functionally limited kludge, which I must avoid.

Do you know a way around this problem that avoids any of these
unwanted scenarios?

Yes.., and is why I offered. Easier to demo than explain so why I asked
for a sample file.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion