VBA: Setting the value of a combo box in code

[dhancy]

I have a form that includes a combo box. That combo box has a "change" event attached to it.

If the user selects a value from that combo box, the "change" event works as it should.

There is one case where I need to select a value for the combo box manually in the code.

I have tried:

cboPasta.value = "Lasagna"

and

cboPasta.listindex = 1

Both set the value in the combo box; however the "change" event isn't triggering.

Is there another approach I can use?

Thanks!


Dennis

 

[dhancy]

This is my "never mind" message.

I was wrong. The change event is triggering in this case. I was undoing the steps completed in the "change" code somewhere else.

Sorry about that. If I knew how to delete my original message on here, I would