How to creat custom made error message in separate window
 

Hi all,
I have created an excel workbook, and now I want to tell the users of this
workbook, that some combinations are not valid. E.g. A car is in 3 models,
1000 cc, 1500 cc and 2000 cc, and for this car is available in 4 colors,
except for the 1500 cc model, there the available colors are reduced to 1
color.
The models are in a separate sheet listed, a vlookup is checking the models
and the available color. I need to have a sort of popup screen displaying
that for model 1500 cc, which in the extra sheet is listed as not available,
the combination with that color is not applicable.
thx
Gerard

How to creat custom made error message in separate window
 

Use Data Validation
--
Gary''s Student - gsnu200805


"noord453" wrote:

Hi all,
I have created an excel workbook, and now I want to tell the users of this
workbook, that some combinations are not valid. E.g. A car is in 3 models,
1000 cc, 1500 cc and 2000 cc, and for this car is available in 4 colors,
except for the 1500 cc model, there the available colors are reduced to 1
color.
The models are in a separate sheet listed, a vlookup is checking the models
and the available color. I need to have a sort of popup screen displaying
that for model 1500 cc, which in the extra sheet is listed as not available,
the combination with that color is not applicable.
thx
Gerard