Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shrinking Listbox from Control Toolbox kumik5000 Excel Discussion (Misc queries) 3 December 5th 08 09:11 PM
Control Toolbox [email protected] Excel Discussion (Misc queries) 1 August 29th 08 05:58 PM
Where is the control toolbox? Sol New Users to Excel 0 November 30th 06 02:20 PM
Control Toolbox ListBox Properties Blank pjhageman[_12_] Excel Programming 2 January 12th 04 03:51 PM
control toolbox robert Excel Programming 1 July 16th 03 08:09 AM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"