Add an horizontal scrollbar to a ListBox control

Add an horizontal scrollbar to a ListBox control

By default, VB ListBox controls don’t display an horizontal scrollbar, so if the items you add to the controls are wider than the control’s Width, the end user isn’t able to read them in their entirety.

Adding an horizontal scrollbar to a ListBox control is easy, however. You only have to increase the so called the control’s horizontal extent, which you do by sending it a LB_SETHORIZONTALEXTENT message. Here’s a reusable routine that does the trick:

Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal _    hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, _    lParam As Any) As LongConst LB_SETHORIZONTALEXTENT = &H194' Set the horizontal extent of the control (in pixel).' If this value is greater than the current control's width' an horizontal scrollbar appears.Sub SetHorizontalExtent(lb As ListBox, ByVal newWidth As Long)    SendMessage lb.hwnd, LB_SETHORIZONTALEXTENT, newWidth, ByVal 0&End Sub

The LB_GETHORIZONTALEXTENT message is useful to retrieve the current value of the horizontal extent:

Const LB_GETHORIZONTALEXTENT = &H193' Return the horizontal extent of the control (in pixel).Function GetHorizontalExtent(lb As ListBox) As Long    GetHorizontalExtent = SendMessage(lb.hwnd, LB_GETHORIZONTALEXTENT, 0, _        ByVal 0&)End Function

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular