could you save the copy you are working with on your computer? And then I'll take a look at what is going wrong? It should repopulate everytime you navigate to another worksheet and then reselect the original worksheet. It's working on my end so I'm not quite sure why it is not working on your end. The combobox values are populated from Column C for the category and E for the Store Number.