Excel 2000 issue with ComboBox list entries disappearing

S

Sunny

version is Excel 2000 SP3

-I have a ComboBox on Sheet two of the Workbook.
-The ComboBox has a ListFillRange of "S2:S9" where i have some text
-Depending on the ListIndex value of the ComboBox, the macro copies some
numbers from one area of the sheet to another.

This works fine until:
-Go to first page
-Select one or more rows at the top of the page
-RightClick and delete the selected rows
-Now, going back to the 2nd page where the ComboBox is, the DropDown list is
shorter. Delete more rows on the first page and the DropDown list gets
shorter yet, eventually the whole list is gone.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top