Listbox not updating after when the command button is used more than once

Hello, I have a tricky VBA problem to describe.

I have created a userform that prompts the user to select answers from 3 comboboxes and sends their responses to an area of the worksheet. This is set up to populate a listbox in the userform, so the users can see a summary of their responses.
The userform will display a messagebox if the user has left any of the comboboxes empty.

The code below is for the command button that sends their responses. My problem is that the first time a user clicks on the command button, the listbox updates and everything works correctly. After the first time, the listbox stops updating although the userform continues to send the user's responses to the correct part of the spreadsheet. Does the 'screenupdating' function need to be looped?

Please Login or Register  to view this content.

Originally Posted by rorya

How is the listbox populated from the worksheet?

It's a named range using the formula below. The listbox also populates correctly if I close the userform and open it again.

Please Login or Register  to view this content.

Originally Posted by rorya

Are you using that in the RowSource property, or using code in the Initialize event to populate it?

I'm using RowSource