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.
|