Hi - I have a number of drop down menus that are connected to values in cells on sheet1. (if choice a, then value in cell is 1, if choice b, then value in cell is 2, etc..) there are 11 cells in all- B14, B19, B25, B29, B34, B39, B44, B49, B54, B59, B64.
I'm trying to find a way to make the drop downs a "mandatory" field for the user to complete. The only way I can think of is to have a button that runs a macro to "check" the values of these cells to see if any have value = 1, then return a message to the user to make sure they have selected a value in every drop down box in column I. There may be another way, but that is where I'm at now. If you have another suggestion great, otherwise if there is a macro vba that would do this I appreciate the help.
thanks
I'm trying to find a way to make the drop downs a "mandatory" field for the user to complete. The only way I can think of is to have a button that runs a macro to "check" the values of these cells to see if any have value = 1, then return a message to the user to make sure they have selected a value in every drop down box in column I. There may be another way, but that is where I'm at now. If you have another suggestion great, otherwise if there is a macro vba that would do this I appreciate the help.
thanks
