Excel 2007 Userform VBA - combo list not updating immediatley

[F0RE5T]

Hi
Excel 2007 Userform with multipages

On one of the multi pages I have fields to create descriptions (saved to a worksheet) that are used by combo box positioned within the other multipages

Everything works great e.g. create, save, amend to worksheet and the new record shows immediately in a combo box positioned within that multipage.

The bug is that if I select another of the multi pages that has a combo box listing those data the new record does not show UNLESS I close then reopen the userform?

Suggestions?

Many thanks for viewing my question even if you cannot help.

Forest

 

[F0RE5T]

Hi

Thanks to all that have viewed my question.

I have remembered an old solution and it works

each time I select the multipage I now refresh the rowsource for the combo box
e.g.
CboMCatDescription.RowSource = "MedicCategories"

I put this in the code for the multipage selected.

Again many thanks and hopefully this may help others.

Forest