Excel 2007 - Userform combobox does not display value

[dean12]

This is kinda weird. I have a userform with a couple dozen controls - a number of them comboboxes. The user enters a value in text field 1. The logic in the AfterUpdate event sets up the combo boxes with values and sets a starting value. There are about 5 combo fields it does this with. When the AfterUpdate finishes we move to the next field in tab order.

Problem is that only 1 of the 5 comboboxes shows a value.

Here's the weird part. If I add a 'DoEvents' statement at the end of the AfterUpdate code then all the combo fields show values - absolutely no other changes. OR - If I step the code in debug mode then again all the combo fields show values. Its like windows says "Oh, too much to do - toss out a bunch of what I'm supposed to do"

Any thoughts?

 

[SkipVought]

Any thoughts?

Any code?


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dean12]

only about 1,973 lines