Combox list with Collection, list getting updated multiple time

[upguy]

Thanks

bakerman2 & AMYasserKhalil, AMjindon. Helping me. I was stunk in this from last two days but in sort time you people resolved my problem. I appreciate your help and work.

Thanks and regards
upguy


Hello Experts,
I have created combo box with using of collection, I have list a (data) in sheet1 range("A1") to Last row (variable). I have added combo-box item with collection.


I am facing issue the number of time I click on Drop down of combo-box the list is updating that number of time.

Please help me to resolve this. I am new to VBA.

Thanks an regards.

upguy