I have 8 pulldown menus that work together to generate a Model number. I
would like this model number to be able to be validated. I need some code or
help on how to write one that when clicked a macro would open and search
through a list of all possible combinations of units to see if the generated
one can exist. If it does exist nothing happens but if it doesnt exist I need
it to have a dialog box that tells the user to change the configuration.
sorry im fairly new to excel and know what i need but dont know how to get
it to happen.