I have a userform with 6 comboboxes and 2 option buttons - all together form a unique identifier. However, there is an ultimate option button which says if the value from all the fields in the userform is "new" or "updated". I would like to check, when clicking on the "update" option button, if the "unique identifier" exists already in a specific column in the worksheet. If the value does not exist in the sheet, a msg box should pop up and don't allow the user to choose update since there needs to be a "new" value first. Furthermore, if I click on the submit button at the end and I have selected "New" without touching the Update button, it should switch automatically to "Update".
How can I concatenate all the comboboxes and option buttons to potentially have the same unique identifier in a stored script or whatever to check within a specific column before allowing to press the button to send the data to the next empty row.
I think this should be done in the UpdateOptionButton_Click() sub for the update-scenario and the overwrite-scenario at the OKToggleButton_Click()