ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control ToolBox ListBox Irratic (https://www.excelbanter.com/excel-programming/287627-control-toolbox-listbox-irratic.html)

Phil Hageman[_3_]

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