Clear data on change of validate list

[d0n]

Is there a command to clear a set of data after i selected something else from a validate list?

[starryknight64]

No, there is not an atomic command that does this, but I'm sure a VB Macro can.

[JBeaucaire]

I use WORKSHEET_CHANGE macros for this sort of thing.

Please Login or Register  to view this content.

That code is in action on this sheet... it insures options made from proceeding drop boxes are cleared if an earlier box is changed later.

http://www.excelforum.com/attachment...dentlists2.xls 2 levels