I have inserted an activex listbox on a spreadsheet.
I am loading values into the listbox, on click action of a button, from database.
There are two issues in am having with this list box
1) the listbox changes its size on its own. I checked the code, this happens at .additem
2) the other major issue i have is, on random occassion, after the listbox is loaded, I am not able to select any values from listbox. I verified the listbox is locked=false.
But this is completely random, if i try loading again, i can select the values from listbox !!
I am working with excel 2007 version.