Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    228

    Red face Unanswered: desperate help on focus

    I have a combobox that is used is used to choose a test case. The user can use the mouse to select from a list or type in a number from the list. If the form loses focus while the cursor is in that combo box, upon return the user is now only able to select with the mouse, the keyboard has no effect on the combo box UNTIL the control loses focus and then regains it.

    Any ideas?
    I can't find any "focus" events for the form in excel vba...

  2. #2
    Join Date
    Dec 2004
    Posts
    37

    Focus

    Hi,
    Look in help for 'Setfocus' this should give you the info you need.

  3. #3
    Join Date
    Sep 2003
    Posts
    228
    it appears that with excel vba setfocus only applies to controls on a form and not the form itself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •