Results 1 to 1 of 1
Thread: ComboBox List Fill Range
2001-03-06, 03:26 #1
- Join Date
- Feb 2001
- Dallas plus 20 miles or so, Texas, USA
- Thanked 0 Times in 0 Posts
ComboBox List Fill Range
In Excel 2000, I have a ComboBox using the range A8:A34 as the listfillrange. Starting with A8 I have words such as "Food", "Paper", etc. I am using the change event basically to "jump" to various places in the worksheet using scrollrow.
Occasionally the contents of the ComboBox will "lose" the first entry (the contents of "A8", "food"), however the space for the entry is still there, but no text is listed in the combo box drop down. Any ideas on what could be causing this? I'm baffled!