I have a combobox in a worksheet and on a userform, both containing the exact
same choices. As soon as a different choice is made in the combobox on my
worksheet, my userform opens. I am struggling with getting the new item
choice from my worksheet populated into the combobox on my userform.

If Sheets("Sheet1").Range("F434").Value = 1 Then
frmFields.txtActivityCmb.ListIndex = 0
End If

I've tried adding the code to UserFrom_Activate, which doesn't work. It does
work when added the code to a macro assigned to the combobox in the
worksheet. But, it doesn't work until the the combobox selection is made a
second time. I think that when the userform is opening, it's not catching
the update in the worksheet yet. Any ideas how I can change the code to
update the change in the worksheet before opening the userform. I don't want
to save the worksheet though; I'd like the user to be able to decide if they
want to save it. Thanks for your help.