Hide listbox scrollbar

Hi all,
I need to hide the scrollbar of a listbox so I can use my own modified control.
I found an VB API that can do that but am having trouble adjusting it to Excel VBA.

Please Login or Register  to view this content.

Now I found that there is no .hwnd property in VBA and Application.hwnd should be able to replace it but in both cases (with or without the Application. part) I get a "method or data member not found" message.

Can anyone help me sort this out?

Much obliged
Nick

Originally Posted by royUK

Why go to all that trouble?

I want to triger some code on a listbox scroll event. Since I couldn't find any way to do it with the listbox scrollbar I figured I'd just use a spinbutton to do the scrolling and triger the desired code with the SpinButton_SpinDown and SpinUp events.

I'm open to suggestions.

Originally Posted by Andy Pope

Still not clear why you need to capture the scroll but how about using a frame control, which has scroll event.
Within the frame could be a listbox, although you will need to have could handling the scrolling of the frame when the list selection changes.
Or you could use a label for each list item, again code would be needed to handle user input via keyboard and scrolling.

Here's the deal. I've already completed the spin button, created a scrolling function and made it to exactly what I want. I just need a way to hide the scrollbar so it doesn't confuse people.

Even if it's not with the API. I tried placing the spin button on top of the listbox but it is always sent to the back. I tried placing a frame on top of the listbox but it also gets sent to the back...

Originally Posted by Andy Pope

The does API for scrolling. It appears to have code to get the handle which would be needed to hide the scrollbar.
http://www.xtremevbtalk.com/archive/.../t-178071.html

Hi Andy. Thanks for the tip. Sadly I'm only managing to get the handle for the entire userform and not the listbox. I'm a novice when it comes to API's.

Please Login or Register  to view this content.

I don't know how to use the FindWindow function for the listbox.
I'd appreciate your help, only if you can spare the time, of course.

Got it. It's a rather crude solution but it works.
Againg - "the why" is my attempt to have a simple on scroll event.
The how - the spin button fulfills the function of the scrolbar and the scrollbar gets obscured with another narrow listbox - the only object you can place above other listboxes.

I know, not very ellegant but it keeps things simple.

Thanks for the help guys, especially you Andy

Originally Posted by romperstomper

The listbox does appear to have a handle (or possibly whatever it is contained in does), but I'll be damned if I can get it to remove the scrollbars, using either the ShowScrollBar method or changing the window style with SetWindowLong.

Let me know if you find something

@Andy - sorry, friend. No simple on scroll event for the scrollbar is enough of a reason for me.