Deleting/Removing a Scrollbar via VBA

[gruberm]

Hello All,

First time poster. I first want to thank everyone that contributes to solutions, it is such a fantastic resource to those of us just beginning our journey into Excel Programming.

My question concerns a module I am writing where I will have added a number of scroll bars to a worksheet, and will have given them unique names. I then have a loop and given a certain condition I want to remove one of the scrollbars via its unique name. I cannot figure out how to delete the scrollbar by the name I have given it.

Please help and thank you in advance.

Matt

[watersev]

hi Matt, welcome to Excelforum, provided the name of the forms scrollbar is "Scroll Bar 2"

Please Login or Register  to view this content.

[gruberm]

Ha could have sworn I tried that already. Got it working. Thank you!