Userform does not update when clicking on dropdown box

[AussieM8]

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.

[AussieM8]

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).

[AussieM8]

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