[RESOLVED] Cancel Combobox Change

[Br1an_g]

Basically have a combobox and on the Change event im bringing up a MsgBox asking whether I am sure I wish to change the value, which is fine. Just need some code to return the combo back to its previous value

cheers

If MsgBox("Status Change: Go ahead with changes?", vbYesNo + vbQuestion, "Status Change") = vbNo Then
    
//Here...... ''

End If

you will need to write the previous value before the change

either using before update or on click.

you will then have the value after update, and your msg box decision will be able to write either value back to teh combo box.