Clear cells from drop down list

T

Tom Jones

Hi there,
Using Data Validation I have created a number of drop down lists that
are dependant on the results of the previous drop down.
My problem is that when a user goes back to the first drop down list all
the other lists keep their last values. Is there any way to clear all the
other cells as soon as someone presses the first drop down arrow?

Any help or ideas would be greatly appreciated
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Formatted cell column in drop down list 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Move Drop Down List to the Top of the Cell 0

Top