+ Reply to Thread
Results 1 to 3 of 3

Userform does not update when clicking on dropdown box

Hybrid View

  1. #1
    Registered User
    Join Date
    08-02-2004
    Posts
    21

    Userform does not update when clicking on dropdown box

    If tried a heap of different ways of getting this to update correctly. I am running a footy tipping competition and attached is a sample of the form I am using.

    If you tab between each item it works, but I would like it to update the userform when you make a selection from the dropdown box.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-02-2004
    Posts
    21
    OK, after some reading it appears the problem is that the dropdown box does not lose focus after a selection.

    So can anyone suggest some code to change the focus from a dropdown box in a form to one of the other items (eg. label).

  3. #3
    Registered User
    Join Date
    08-02-2004
    Posts
    21
    Solved it .. it was quite simple really.

    I just used a SendKeys statement to add a {TAB} which forced the focus to the next tabstop.

    Here's the code:

    Private Sub ComboBox1_Change()
    SendKeys "{TAB}"
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1