great video! lots of useful insight on the features, thanks!
@shreyajadhav7264
2 жыл бұрын
Nice explanation...sir 🙂 thank you 🙂
@PedroAugusto-yu8yc
Жыл бұрын
Really helpful. Thanks!
@alphabeta9032
2 жыл бұрын
Very Helpful. Thank you very much :)
@Darioq57
2 жыл бұрын
How do I use that scrollbar with a growing datasheet?
@abunousher2230
3 жыл бұрын
I want that y the scroll bar will be in the reset positon(0) when I open the sheet. Is it possible ? Thanks.
@stoker303
4 жыл бұрын
Hello, is possible to use like start value negative number for example -20? I set the minimum value at -20 but after set this value on scroll bar, the linked cell shows 65535. Thank for help.
@profneilwalker
4 жыл бұрын
Sure, if you wanted the scrollbar to control a value from say -20 to +20, you would take the raw value (0-32,767) from the linked cell, divide it by 32768, (which scales the scrollbar value to a range from 0 to 1) multiply by your range (20- -20=40) which gives a range from 0 to 40, and add your offset (-20) to shift the range from -20 to +20. E.g. if your linked cell is A1, then in cell A2 put the formula =A1 / 32767 * 40 - 20. I don't screw around with the limits in the scrollbar properties. Instead, take the entire 0-32767 range and scale it to your limits. Cheers
Пікірлер: 9