Hello,
Is there possible to change the color on the scroll bar when I click the button from the worksheet?
Please check the Sheet1 where it will show what I am trying to accomplish.
If you go to "CODE" sheet and click the button you will the scroll bar that has the gray color which I want to change it to red.
Thank you.
Last edited by 6StringJazzer; 08-28-2018 at 11:21 AM. Reason: enhanced title
I don't believe you can using the properties available, but happy to be proved wrong.
Colours come from Windows setting for controls, so whilst you could alter the colour it will affect all scroll bars.
If you really need colour you will need to construct your own listbox using other controls and a scrollbar.
.
https://docs.microsoft.com/en-us/win...rs-and-metrics
Scroll Bar Colors and Metrics
The system-defined color value, COLOR_SCROLLBAR, controls the color within a scroll bar shaft. Use the GetSysColor function to determine the color of the scroll bar shaft and the SetSysColors function to set the color of the scroll bar shaft. Note, however, that this change of color affects all scroll bars in the system.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks