I have a comboBox with the values 1 - 10. If the user selects 5 I want to prompt message.

if combobox.value = 5 then
msgbox "You have selected 5"
end if

I am sure this is easy I just can't figure it out. I have tried onChange, Validate, but these seem to also occur when you move from one record to the next and the value in the combo box changes. If I place code in the on click, it executes prior to the user actually selecting a value on the drop down. I only want it to execute when they have finished selecting the value. The best thing I have found so far is to do it on lost focus but that requires them to leave the field and go to another.

I hope I have made sense.

Thanks in advance