View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default 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.