Thanks Jim! I think I was mis-reading your OP. I needed to "UnLoad" the form
each time rather than "Hide" it. That seems to have taken care of the issue.

But, I am still not using the "UserForm_Activate" sub. Do you think I still
need to do that to prevent other issues?

"Jim Thomlinson" wrote:

But you have a UserForm2 form. In the VBE there are a number of events
associated with the form. One of them should be active. Place the code into
this event.

This code goes right in the form...

Private Sub UserForm_Activate()
MsgBox "Load the combo Box here..."

End Sub

"quartz" wrote:

Jim, thanks for your reply.

The user doubleclicks in column "A" of "Time Sheet" to call Userform2.Show.
When the user clicks "OK" or "Cancel" it calls UserForm2.Hide.

This doesn't work. But, my code in the "Time Sheet" class module will not
function with "UserForm2.Activate". How can I get this to work?


"quartz" wrote:

I have a user form that is populated using an array. The array is based on
one of two columns. If column B is blank, then column A is used, if column B
contains anything at all, then column B is used to populate the ComboBox on a
user form.

It works fine, except that if a change is made in column B, the change isn't
reflected the next time the user form is loaded. How can I enforce immediate
changes such as this?