Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I set the Min and Max value for a scroll bar to be equal a variable cell value in Excel?
When I go in the properties for the scroll bar it only allows me to enter a numeric value for Max and Min. I want to set those equal to a variable cell value. How do I do that?
1 Answer
- Anonymous1 decade agoFavorite Answer
You can not do this in the easy way, you have to use macros (VBA) to access the properties of that scrollbar in code
Sheet1.Shapes("Scroll Bar 1")..Min = 1
Sheet1.Shapes("Scroll Bar 1")..Max = 1
Where Sheet1 is the name of your sheet (Not Tab Caption)
Mail me for more info
Enjoy my profile, I am the VBAXLMan