fullscreen changes corrupt display of listbox control

G

Guest

I have a list box on a splash screen excel sheet.

I have put the fullscreen menu choice on the main menu for ease of access by
users of my workbook.

When the sheet is activated, the list box is loaded with all worksheets
meeting my criteria (in this case, if the worksheet name contains the text
"DSH"). Instructions on the page tell the user to choose a worksheet from the
list.

This all works exactly as needed.

The problem is that when fullscreen mode is entered or exited when this page
is displayed, the display of the listbox is corrupted. The top of the listbox
is overwritten by what was previously displayed at that point on the screen.

I have bitmaps showing this, but I can't attach them to this posting, to
anyone interested, let me know and I'll send them to you.

I would like to know if there is a "refresh" or trick I can use to update
the window or control programmatically to reset it's true image. (I can put
that code into the routine which executes fullscreen.)

I am running excel version 2000, 9.0.8961 SP-3 on a windows 2000 machine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, Fullscreen, Taskbar 5
Display a range fullscreen 2
When first displaying a sheet -List box is not filled in. 1
Lost clipboard contents on Workbook_Activate 3
Centralize forms on any size screen in fullscreen 2
Populating a listbox from an excel column 2
ListBox Size and Screen Resolution 2
Listbox ? 1

Top