Hi,

I have two user forms in my spreadsheet that are launched by pressing a keystroke.
I want both of them to activate the search button located in each when I press the enter key. I have set the default button property for the search button to true on both forms.
However, this is unreliable. I have a few cells in my worksheet that have hyperlinks and if I load one of the forms when the keyboard focus is in one of these cells and then press enter when the user form is active, it activates the hyperlink in the worksheet instead.
Sometimes it will activate the default button on my user form but it is unreliable. How do I stop keypresses from being passed to the underlying worksheet? This is the code I am using to load the forms:


If Not frmPlaceSearchDialog.Visible Then
frmPlaceSearchDialog.Show vbModal
End If