![]() |
Control ToolBox ListBox Irratic
I have inserted a ListBox from the Control ToolBox, and
entered a cell range in ListFillRange. ListBox works great up to this point. However,when I close and reopen the workbook, the listbox does not initially appear. Rather, ghost text from other cells in the worksheet appear where the text box should be. When I click around in different cells in the worksheet, the list portion then appears. Then when I click in the up arrow place, it appears; and when I click in the down arrow place, it appears. Other unusual things: the curser turns into a cross (versus arrow pointer), and the first name on the list reverses colors - white to blue background, black to white font. Any idea of what's going on? I can't figure any logic in all this. |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com