How to creat custom made error message in separate window

N

noord453

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create custom wildcard for searches? 2
Excel 2010/2007 - How much can be done with Custom Validation? 6
Display multiple results in 1 cell 1
Windows 10 Windows 10 Fall Creators Update 15
Multiple criteria with multiple results in one cell 4
Creating VBA Functions When Creating Spreadsheet Via VBA? 6
Microsoft Internet Explorer window.createPopup() method creates chromeless windows 0
Fatal Error in creating worksheet 1

Top