In my Excel sheet I have a column that was filled up with a list of values to be selected.
When the user didn't select an item from the list and tried to save, I would like to show a message box stating that you have to select an item – or is there any option to make the
first item get selected from the list?
AddressType this i am calling in my next sheet in which ever
column i required by using
Data validations available so that it comes as follows
By default i would like to select
Office or if the user didn't select any i would like to display an error message