In a user form I have two combo boxes that contain dependant data. When one
box is changed, the other box gives a list that changes based on the others
selection.

I have the data entered on the form to populate a cell on xyz_change().
This data is not reflected in the form until it is closed and opened again,
and then the second combo box shows the dependant information.

Is there a way to update the user form without closing it and opening it?

If not, how do you have the textbox in the form pull data from a cell on
activation?

Sorry if the question is not clear enough, I find it kind of hard to explain.

Thanks

Dave