HarryB
02-24-2005, 02:41 AM
Hello,
I have an Excel spreadsheet that uses a combobox to allow me to choose a name from a list and put it in another cell. This has worked fine for 5 years, but suddenly has started reading only 30 names from the list.
The list changes in length and at one stage was about 170 names long, which the combobox read without difficulty.
This all used to run on a W98 machine and is now on an XP Pro machine with Excel 2002. I'm not aware that the problem started with this change but it is possible. I've crawled all over the properties and cannot see anything that would affect this. I've tried making a new combobox (using the Forms COntrol) and this also seems to read more than 30 names, but would mean re-writing all the macros (which I did 5 years ago and took me ages....:dunno)
Can anyone help with this...:motz2:?
I have an Excel spreadsheet that uses a combobox to allow me to choose a name from a list and put it in another cell. This has worked fine for 5 years, but suddenly has started reading only 30 names from the list.
The list changes in length and at one stage was about 170 names long, which the combobox read without difficulty.
This all used to run on a W98 machine and is now on an XP Pro machine with Excel 2002. I'm not aware that the problem started with this change but it is possible. I've crawled all over the properties and cannot see anything that would affect this. I've tried making a new combobox (using the Forms COntrol) and this also seems to read more than 30 names, but would mean re-writing all the macros (which I did 5 years ago and took me ages....:dunno)
Can anyone help with this...:motz2:?