View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default How do I create validation lists which change based on another lis

Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.