PDA

View Full Version : Solved: Msgbox if Something is Entered Different from Values in Combobox



Ethan
09-22-2011, 02:11 AM
Hello all,

I use Combobox on a userform.
It is populated, using a dynamic named Range.
I'd like a messagebox to pop up when a something is entered in the combobox which is not available in the range.
It's ok is the messagbox shows up after hitting a button

Bob Phillips
09-22-2011, 03:24 AM
Private Sub ComboBox1_AfterUpdate()
If IsError(Application.Match(ComboBox1.Value, Range("bob"), 0)) Then

MsgBox "New value"
End If
End Sub

Ethan
09-22-2011, 09:12 AM
Thank you very much!