Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Clear cells from drop down list
0 views
Skip to first unread message
Tom Jones
Jan 14, 2004, 5:09:26 PM1/14/04
to
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?
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
0 new messages