View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Auto move scroll bars of listbox

Look at the topIndex property of the Listbox.

--
Regards,
Tom Ogilvy

"JON JON" wrote in message
...
Dear Ng,

I had created a user form which is not modal that serves as splash screen
while my macro runs into the background. This userform includes a

listbox
that is populated during runtime. My problem now is that when the

entries
in the listbox exceed beyond it size, the latest entries are being hide

in
view. Is there a way that I can move the scroll bars of the listbox so

that
I can show the latest entries in view.

All help will be highly appreciated.

Regards,

Jon-jon