VBA to fill scroll bar with colour when moved

Hello michelle 1,

...is there a way to fill a scroll bar with colour when moved to show progress?

The "scroll bar" you mention actually is a Progress Bar, and yes, it should be possible to play like a "genie chameleon". Since there are many different ways people employ a Progress Bar, I would like to suggest that you attach a sample workbook, of how you have it set up.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you for the feedback michelle,

Pie in the face for me! I did not for one moment think that you were actually referring to an Active X ScrollBar.

Try as I may, it just don't seem possible for me to do what you want.

It would be nice to see if someone could come to your rescue, as it really looks very professional !

Good luck.

Wait a day or so, and if you have not received any further assistance, "Bump" your Thread!

Hello michelle 1,

Very much like a pit-bull, I very seldom let go of a challenge!

Please try the attached sample Workbook below.

Regards.

Thank you for the feedback and kind words michelle,

Unfortunately I, or rather Excel, cannot accommodate your last proposal. You could however search for an Add-in like Ku-Tools for instance, but that would limit the functionality of same, if available, to your Workbook only, unless you share it with someone with the same Add-In.

So sorry 'bout that!

Kind Regards.