Data Validation lists

[greg]

Hi I would like to do the following in VBA .

1>create 3 data validation lists
2>make the second one dependent on first
3>make the third one dependent on second

all 3 steps need to be done in VBA .
code samples will be greatly appreciated.

 

[Bob Phillips]

http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[greg]

Bob,

The site gives details about combo boxes. However I need to create a
validation list in
VBA and then make them dependant.

Typically each row of the application will contain 3 validation lists
and if the primary list is modified, the dependant list in the
corresponding row should get modified.

Any pointers?










*******************************************************************************************

 

[Bob Phillips]

If you read on, there is a Data Validation version.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)