troubleshooting Question

Check for duplicates from current selection in combobox and compare to existing values in column

Avatar of Nico Caprez
Nico Caprez asked on
Microsoft OfficeMicrosoft ExcelVBA
8 Comments1 Solution67 ViewsLast Modified:

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()
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros