View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I create validation lists which change based on another lis

goto

http://www.contextures.com/tiptech.html
Debra Dalgleish's site and look at

Data Validation - Dependent Lists

--
Regards,
Tom Ogilvy


"Jamesmor" wrote in message
...
Pete,

I have a similiar problem, but don't actually have Excel Hacks, can you

give
me an idea how to get started with this?

"Pete" wrote:

I have tried the example in "Excell Hacks" but it is too complicated to
extend over more than 2 columns. I would like to extend to 10 columns.

A
VBA solution would be OK if necessary.