This still doesn't make it. Will try to play around.
It has something to do with the screen not refreshing the display of the
listbox control.
Anyway to programmatically control the scrollbar on a listbox? (as clicking
on the control itself and scrolling down an up refresh the list)
Thanks guys
"chijanzen" wrote:
Ben:
add this code to Thisworkbook Module
'Thisworkbook
Private Sub Workbook_Open()
Sheet1.Shapes("Listbox1").DrawingObject.Object.Top Index = 0
End Sub
Control Toolbox Controls
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Ben" wrote:
Hi,
I am using a listBox filled using ListFillRange.
However, when I open the spreadsheet, the LB appears as blank, I need to
scroll down and then up to refresh the display
Any trick to force the listbox to refresh its appearance?
Thanks
ben