Use

Private Sub UserForm_Initialize()
Me.ComboBox3.SetFocus
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"David Coleman" wrote in message
...
Hi

I've got a userform (called stagedetails) with a combobox
(called combobox3) that should always be the active control
when the form is shown.

It works perfectly the first time but once a button on the form
has been clicked I can't change the focus back.

The form can be seen at www.thestormdragon.com The default
button is "Save and Return".

I've tried unloading and reloading / hiding and showing but it
makes no difference and the vba code of

stagedetails.combobox3.setfocus

doesn't work.

I've searched through this group and the google group archives
without success. Any ideas?

Many thanks

David