Indirect validation possibility?

[Guest]

I am using Excel 2002

I would like to have a Validation list appear in a the cells in column 3 if the cells in column 1 have "CAE" as a part of their text; otherwise I would like to have the cells in column 3 behave as if they have no validation list (i.e. no dropdown arrow appears when any of the cells are selected)

Is this possible; does anyonne know how to do it

TIA

Joe

 

[Don Guillett]

In which group would you like your answer?

--
Don Guillett
SalesAid Software
(e-mail address removed)

I am using Excel 2002.

I would like to have a Validation list appear in a the cells in column 3

if the cells in column 1 have "CAE" as a part of their text; otherwise I
would like to have the cells in column 3 behave as if they have no
validation list (i.e. no dropdown arrow appears when any of the cells are
selected).

 

[Tom Ogilvy]

Turn on the macro recorder and set up the validation you want.

Now go to the calculate event of the worksheet and incorporate that basic
code in a loop through the cells in column 3.

If calculate doesn't update it frequently enough, then you can use the
selection change event (not sure how CAE is produced in column 3, so you
would have to be the judge of what event is best to use).

--
Regards,
Tom Ogilvy

I am using Excel 2002.

I would like to have a Validation list appear in a the cells in column 3

if the cells in column 1 have "CAE" as a part of their text; otherwise I
would like to have the cells in column 3 behave as if they have no
validation list (i.e. no dropdown arrow appears when any of the cells are
selected).

 

[Guest]

THis one is fine


----- Don Guillett wrote: ----

In which group would you like your answer

--
Don Guillet
SalesAid Softwar
(e-mail address removed)

I am using Excel 2002

if the cells in column 1 have "CAE" as a part of their text; otherwise
would like to have the cells in column 3 behave as if they have n
validation list (i.e. no dropdown arrow appears when any of the cells ar
selected)

 

[Guest]

Hi Tom

CAE is in column 1. It is populated from another validation list.

What would this loop do? I'm still not clear on what you are suggesting

Thanks

Jo

----- Tom Ogilvy wrote: ----

Turn on the macro recorder and set up the validation you want

Now go to the calculate event of the worksheet and incorporate that basi
code in a loop through the cells in column 3

If calculate doesn't update it frequently enough, then you can use th
selection change event (not sure how CAE is produced in column 3, so yo
would have to be the judge of what event is best to use)

--
Regards
Tom Ogilv

I am using Excel 2002

if the cells in column 1 have "CAE" as a part of their text; otherwise
would like to have the cells in column 3 behave as if they have n
validation list (i.e. no dropdown arrow appears when any of the cells ar
selected)