Thread: Userform Focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Coleman[_4_] David Coleman[_4_] is offline
external usenet poster
 
Posts: 8
Default Userform Focus

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