I haven't looked at Julie's file, but in Excel 97, selecting an item
from a Data Validation dropdown list doesn't trigger a Change event,
unless the list items have been typed in the Data Validation dialog box.


Max wrote:
"JulieD" wrote

try the refresh button it might be cached ...
the file is at the end of the Excel bit called
SAMPLE WORKBOOK Dependent data validation lists using VBA.


Thanks, Julie. Got the file now.
But I seem to have a problem getting it up (macros are enabled).
Does it work in Excel 97 (my version) ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html