Hello and Help with dropdown list with error control

T

The_Sleeper

Greetings all!!!

I am new to the group. thanks to the owner of the group for creating
it. I work for a cement company and i have made a excel sheet with
mixing of diffrent types of cements. I would like to know if anyone can
help. the problem is this i have a list of additives for each blend.
one can select them from a dropdown list. But some of the additives are
no conpatable with each other. So i want to setup a message box or a
popup box the will tell the person that they are not conpatable. right
now i have a match formula and a if formula in place. I am pretty sure
there is a better way of doing it.
 
B

Biff

Hi!

Why don't you just limit the additive selections to only those that are
compatabile with that specific type of cement?

Biff
 
S

Stopher

epending on how many addatives you have in your drop downs, you could
set up a On_change macro with nested If statements that could limit the
list of the second selection box based on the selection of the first
and so on and so on.
 
T

The_Sleeper

Biff said:
Hi!

Why don't you just limit the additive selections to only those that are
compatabile with that specific type of cement?

Biff
Click to expand...

Thanks Biff
I was going to do that but it's up to the consultents to pick
what that want to put in it to start. We have about 45 basic blends
then they add the additives and it also deppends on the temp of the
hole and depth of it and how slow or how quick they want it to set up.


That you for the quick reply
 
T

The_Sleeper

Roger said:
Hi

Take a look at Debra Dalgleish's instructions on the use of Data
Validation
http://www.contextures.com/xlDataVal01.html

Debra has a nice example workbook at her site that will probably suit
your needs if you set up a matrix of compatibility similar to that in
this workbook.
http://www.contextures.com/DataValLookupList.zip
Click to expand...


Thanks Roger that would work for what i need to do. i just need to add
something to it so it will look at the blend and see whats in it change
the list to not list what is in the basic blend and non conpatables


thanks for the reply

Leo L'Hirondelle
 
Top