keypresses being passed from user form to worksheetn

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

Hi gbeats101,
I have a user form with text fields and combo boxes in it. I want to be able to press the enter key and for it to activate the search button located on the form. I have set the default button property for the search button to true.

However, when I press the enter key when in the user form, it gets passed through to the underlying worksheet. The search button is activated sometimes but sometimes it isn't.

I want to stop the enter key from being passed through to the underlying worksheet when I press it in any of the text boxes and combo boxes in my user form.

Hi gbeats101,

To launch my form, I press the keystroke Ctrl + P in excel.
When the form loads, the focus is in a text box control.
If I type in the text box and press enter, it should activate the default button which is set to the search button located on the form.
However, the enter key seems to get passed through to the underlying worksheet and doesn't activate the search button reliably. I have to use the accelarator key (alt + s) to activate the search button or tab to the search button and press enter.

I'm blind and using some screen reading software. I have been doing some more testing and I think it may have something to do with that and it not changing the focus from the worksheet to the form when the user form is launched. If I press alt + tab to move away from Excel and back again then pressing the enter key works as expected.

Originally Posted by gbeats101

im still not sure exactly what is happening here........

looking back at your first post, it looks like you have a form that is open modal and if the focus is set to the worksheet and the user presses enter on a cell in the worksheet then you want to.....activate your button...(make it visible, run the code as if it was pressed..be very clear)


now looking at your second post......what is the default button property? how is pressing enter when the focus is on your form affecting the worksheet if your not telling it to do that, unless your trying to capture something your typing in the formula bar while in edit mode which (i have not tested but) may force excel out of edit mode applying the changes before processing the enter key......

you need to be very specific on what is happening, step by step so we can get this whole picture. something doesnt quite add up here.