Load items in combobox

Hi,

Im very new to excel vba. I have created a combobox from the control toolbox and have tried to populate it using the following code:

Please Login or Register  to view this content.

which resides in the a worksheet object. The problem is that whenever i open the workbook, the items are no longer filled in the combobox.

Can anyone point out what im doing wrong? Thanks in advance!

Thanks for the response.

I have tried that and it still does not work as desired.

What happens is that when i open the workbook, all the items are not filled in the combobox. However, only if i go to another worksheet and then back to the worksheet with the combobox will all the items appear.

Any ideas?

Thanks again.