I have a multi-page UserForm in Excel and after I entered a name into a ComboBox and it's related fields, I then press a button to add/update that information to an underlying worksheet called 'CandidateData', next I proceed with entering the next name into the ComboBox and so on. But, I found as I tested this process that I cannot find the names of those candidates I have just entered within the combobox drop down arrow - the names are not there. But, when I closed the UserForm to see if the candidates were in the CandidateData worksheet, they were there.

When I reopened the UserForm, I could then see the names of all three candidates entered in the ComboBox drop down. Then, when I add yet another name or two those new names are still not shown in the drop down of the Combobox, while the ones previously entered are seen. The new one's won't be seen until I close the UserForm and re-open it.

How can I fix this so they will be seen without having to close the UserForm?