| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| Multicolumn Listbox and ordinary listbox | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Hybrid Mode
