Re: Problem with sub..._Change

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'll give that a try. Thanks!


Bob Phillips wrote:
How about the combo's DropButtonClick event. It only gets loaded then when
someone goes to use it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jacob" <jlongton@xxxxxxxxx> wrote in message
news:1160488077.065773.238160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I use a sub to update the options in a listbox based on the selection
of a combobox. I have it set to update when the combobox changes:

Private Sub ComboBoxgroupW_Change()
With UserFormDesign
.ListBoxW.RowSource = .ComboBoxgroupW.Value
End With
End Sub

this is causing problems when the main program is running because
apparently it updates as the main function iterates, and this statement
assigns bad input to rowsource when the function has not completed
running. Is there a better option to use than "Change." Or is there a
way to disable this sub while the program is running? thanks


.

Quantcast