in your userform_initialize sub, put

CommandButton1.setfocus

hth
:)
susan

On Jul 1, 10:57*am, "Sandy" wrote:
I have a form which opens when excel opens

* * If Sheets("SearchRoundsData").Range("B2").Value = 1 Then
* * * * frmWelcome.Hide
* * Else
* * * * frmWelcome.Show
* * End If

On the form there is a close button "CommandButton1". Is it possible to give
this button focus so that the user can use the Enter keyboard key rather
than having to click with the mouse?

Thanks
Sandy