Is there a way to refresh the combo box after creating a new record in the
worksheet?

I have a simple form that enters Names & Sales units to the worksheet...I
also have a combo box on the same form whose row source is the names.
After I add the record by using the on click event, how do I refresh the
combo box at the same time?