Not In List Data Additions - Default MSGBox to No?

[Guest]

I have a MSGBox prompt that appears on my form if someone enters text into a
Combo box that's not in that list. The MSGBox basically says "XXX is not in
the list, do you wish to add it?" There's a yes and a no tick box.

The problem is that the Yes option is always highlighted so if the user
presses enter by accident, that entry is added. How do I get the MSGbox to
have No highlighted by default instead of Yes?

 

[Allen Browne]

Use:
MsgBox("Add it?", vbYesNo+vbDefaultButton2)

 

[Guest]

Thanks Allen.

That was easy! But I couldn't find that info anywhere.