Message-ID:

Quod licet Iovi non licet bovi. (What Jove may do, is not permitted to a cow.)

computers / microsoft.public.excel.misc / Re: how blank data validation cell after changing dependent cell?

Re: how blank data validation cell after changing dependent cell?

<2ba51935-dd54-4260-8dc7-711f0e782a90n@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=328&group=microsoft.public.excel.misc#328

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:ac8:7fcd:0:b0:2f3:3cb5:42b9 with SMTP id b13-20020ac87fcd000000b002f33cb542b9mr5995972qtk.559.1650501619844;
Wed, 20 Apr 2022 17:40:19 -0700 (PDT)
X-Received: by 2002:a9d:7608:0:b0:5e9:5b29:bef8 with SMTP id
k8-20020a9d7608000000b005e95b29bef8mr8417754otl.368.1650501619584; Wed, 20
Apr 2022 17:40:19 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Wed, 20 Apr 2022 17:40:19 -0700 (PDT)
In-Reply-To: <4A8763FC.7010605@contexturesXSPAM.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2806:2f0:3500:c90:8455:d22d:aaad:e5a4;
posting-account=0g-kqwoAAACAKc8HIBaGY94Cstp3kLR3
NNTP-Posting-Host: 2806:2f0:3500:c90:8455:d22d:aaad:e5a4
References: <48DF0AE6-B768-4A8B-BCD7-17DFA354B813@microsoft.com>
<#obkvZIHKHA.4316@TK2MSFTNGP04.phx.gbl> <2992A7C6-93B9-4A2A-9211-FAAD46797A47@microsoft.com>
<4A8763FC.7010605@contexturesXSPAM.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <2ba51935-dd54-4260-8dc7-711f0e782a90n@googlegroups.com>
Subject: Re: how blank data validation cell after changing dependent cell?
From: and...@heroguest.com (Andrea Piñón)
Injection-Date: Thu, 21 Apr 2022 00:40:19 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 48

by: Andrea Piñón - Thu, 21 Apr 2022 00:40 UTC

On Saturday, August 15, 2009 at 7:42:20 PM UTC-6, Debra Dalgleish wrote:
> Another option is to make the first drop down list dependent on the
> second list too. There's an example here:
> Prevent Cheating With an Excel Drop Down List
> http://blog.contextures.com/archives/2009/07/27/" rel="nofollow" target="_blank">http://blog.contextures.com/archives/2009/07/27/
> Ian Elliott wrote:
> > 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.
> >>
> >>
> >>
> --
> Debra Dalgleish
> Contextures
> www.contextures.com/tiptech.html
> Blog: http://blog.contextures.com

Is there a way to select the first option (instead of clearing) on the dependent dropdown when modifying the first list?

Subject	Author
Re: how blank data validation cell after changing dependent cell?	Andrea Piñón