ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   scollable listbox (https://www.excelbanter.com/excel-programming/330205-scollable-listbox.html)

RB Smissaert

scollable listbox
 
Found some nice code on:

http://www.enhanceddatasystems.com/E...istScrolls.htm

to make a scrollable listbox.
The scrolling works perfect, but there are serious side-effects.
After doing some scrolling you can't move or even close the form anymore
and the only way out is Ctrl + Alt + Del.

Does anybody have a solution for this or does anybody has some better code
for this?
Maybe the answer to this is to use a VB6 listbox in Excel as I understand
that you can
do this. It just looks a bit more complex.

Thanks for any advice.


RBS


Tom Ogilvy

scollable listbox
 
Since listboxes are already scrollable, it would have been clearer to say "
.. . . using a mouse wheel" or words to that effect.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Found some nice code on:

http://www.enhanceddatasystems.com/E...istScrolls.htm

to make a scrollable listbox.
The scrolling works perfect, but there are serious side-effects.
After doing some scrolling you can't move or even close the form anymore
and the only way out is Ctrl + Alt + Del.

Does anybody have a solution for this or does anybody has some better code
for this?
Maybe the answer to this is to use a VB6 listbox in Excel as I understand
that you can
do this. It just looks a bit more complex.

Thanks for any advice.


RBS




RB Smissaert

scollable listbox
 
Yes, you are right. Will rephrase and repost.

RBS

"Tom Ogilvy" wrote in message
...
Since listboxes are already scrollable, it would have been clearer to say
"
. . . using a mouse wheel" or words to that effect.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Found some nice code on:

http://www.enhanceddatasystems.com/E...istScrolls.htm

to make a scrollable listbox.
The scrolling works perfect, but there are serious side-effects.
After doing some scrolling you can't move or even close the form anymore
and the only way out is Ctrl + Alt + Del.

Does anybody have a solution for this or does anybody has some better
code
for this?
Maybe the answer to this is to use a VB6 listbox in Excel as I understand
that you can
do this. It just looks a bit more complex.

Thanks for any advice.


RBS






All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com