On Friday, August 14, 2009 at 10:29:50 AM UTC-6, T. Valko wrote:
Ok, what you want to do is to clear the contents of the dependent cells whenever a new selection is made from the parent drop down list.
This requires an event macro.
Select the sheet with your drop downs
Right clcik the sheet tab and select View code
Copy paste the code below into the window that opens
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo sub_exit
If Target.Address = "$B$1" Then
Range("B2:B3").ClearContents
ElseIf Target.Address = "$B$2" Then
Range("B3").ClearContents
End If
sub_exit:
Application.EnableEvents = True
End Sub
Close the window and return to Excel
--
Biff
Microsoft Excel MVP
"Ian Elliott" <IanEl...@discussions.microsoft.com> wrote in message news:2992A7C6-93B9-4A2A...@microsoft.com...
Thanks for offering to help, Valko.
No, I have 2 primary & 1 dependent (or maybe the right way to look at it
is
1 primary & 2 dependent). The 1st primary is B1, the 1st dependent is B2, and
the 2nd dependent is B3.
"T. Valko" wrote:
Do you have just 1 primary drop down and 1 dependent drop down? If so,
what
cells are they in?
--
Biff
Microsoft Excel MVP
"Ian Elliott" <IanEl...@discussions.microsoft.com> wrote in message
news:48DF0AE6-B768-4A8B...@microsoft.com...
Thanks for any help.
Using http://contextures.com/xlDataVal02.html, I have a data validation >> > dependent on another data validation. So when I change the original
data
validation, and then change the dependent data validation, I only get a >> > choice based upon the original data validation. However, before I
choose
for
the dependent data validation, if I had a previous choice that wasn't
possible, that value will still remain, even if I choose the original
data
validation something that won't have that dependent value. Is there a
way
to
blank out the dependent if it won't be allowed?
Sorry if that's confusing.
Is there a way to select the first option (instead of clearing) on the dependent dropdown when modifying the first list?
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)