Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox displaying incorrectly on opening worksheet
Hi,
I have a Listbox. When I first open the spreadsheet, the Listbox values text don't visually appear. I can click on the spots in the listbox where the text is and thereafter it appears. Alternately, if I switch tabs and then come back it also shows properly. It seems to be due to ScreenUpdating; however I do this after the values have been populated (same result putting it before). If the ScreenUpdating portion is completely removed, it displays the values text properly. However, I'd prefer to have ScreenUpdating disabled for the second section of code. I'm populating the values in Workbook_Open, code as below. Thanks, Scott ------------------------------------------------------- Private Sub Workbook_Open() Dim i As Long 'Application.ScreenUpdating = False '<== Initial position of ScreenUpdating With wksMomMpaScatter For i = 0 To ReportPlantsInfo.Range("ReportPlantListFull").Coun t - 1 .ListBox1.AddItem ReportPlantsInfo.Range("ReportPlantListFull").Cell s(i + 1, 1) .ListBox1.Selected(i) = ReportPlantsInfo.Range("ReportPlantListFull").Offs et(0, 1).Cells(i + 1, 1) Next i End With Application.ScreenUpdating = False '<== Alternate position for ScreenUpdating .... {Other code} .... Application.ScreenUpdating = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox displaying incorrectly on opening worksheet
hi Scott,
the file is it in shared mode ? -- isabelle |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox displaying incorrectly on opening worksheet
sorry for my poor english,
does this file is in shared mode ? -- isabelle |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox displaying incorrectly on opening worksheet
If it's just a display problem -- and it sounds like it is, since the program
works fine if the screenupdating portion is removed... Maybe you can add a change sheet and change back at the bottom of your code. And if that fails, do it with screen updating on. You'll have a bit of flashing, but at least it'll show correctly. On 11/25/2011 18:05, Scott wrote: Hi, I have a Listbox. When I first open the spreadsheet, the Listbox values text don't visually appear. I can click on the spots in the listbox where the text is and thereafter it appears. Alternately, if I switch tabs and then come back it also shows properly. It seems to be due to ScreenUpdating; however I do this after the values have been populated (same result putting it before). If the ScreenUpdating portion is completely removed, it displays the values text properly. However, I'd prefer to have ScreenUpdating disabled for the second section of code. I'm populating the values in Workbook_Open, code as below. Thanks, Scott ------------------------------------------------------- Private Sub Workbook_Open() Dim i As Long 'Application.ScreenUpdating = False '<== Initial position of ScreenUpdating With wksMomMpaScatter For i = 0 To ReportPlantsInfo.Range("ReportPlantListFull").Coun t - 1 .ListBox1.AddItem ReportPlantsInfo.Range("ReportPlantListFull").Cell s(i + 1, 1) .ListBox1.Selected(i) = ReportPlantsInfo.Range("ReportPlantListFull").Offs et(0, 1).Cells(i + 1, 1) Next i End With Application.ScreenUpdating = False '<== Alternate position for ScreenUpdating .... {Other code} .... Application.ScreenUpdating = True End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my formated column is displaying one cell incorrectly | Excel Worksheet Functions | |||
Number of Copies for worksheet defaults to 5 incorrectly | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
DISPLAYING INFO IN A LISTBOX | Excel Programming | |||
Displaying a specific worksheet on opening application | Excel Programming |