Check duplicate value from combobox in a database and overwrite existing row in database

[Mac1234]

Hello,
I have a database called DatabaseCB in which I want to check all of the entries in column C. If the value being entered in the 'cmbSD' combobox in the userform already exists in column C in the 'DatabaseCB' sheet I would like to overwrite the entire row with the new data (ie, "=Row() - 1" in column A, "txtSID" in column B, "cmbSD" in column C etc.). Any help is appreciated.

 

[dmt32]

Hello,
I have a database called DatabaseCB in which I want to check all of the entries in column C. If the value being entered in the 'cmbSD' combobox in the userform already exists in column C

Hi,
You can use the Range.Find method in you code to first check for a values existence in the range

something like

  Search = Me.cmbSD.Text
    Set FoundCell = Worksheets("Database").Columns(3).Find(Search, lookat:=xlWhole, LookIn:=xlValues)
'if exists - return record row
    If Not FoundCell Is Nothing Then RecordRow = FoundCell.Row

'your code

If need further guidance post your code - plenty here to assist you

Dave