Scrollbars in Excel - Sorted

Last edited by rogwilco on Tue Sep 29, 2009 2:44 pm, edited 1 time in total.

Anybody used them before?

I've got two scrollbars on my graph that are used to control values for the X and Y axis and they work fine until they get to negative values. The value goes from 0 to 655351? I've made sure that the cell in question for the value is of type number, etc. Any ideas?

Spreadsheet is here if you want to take a look: http://www.mediafire.com/?gzdqmyxpm1x

Thanks!

PostRe: Scrollbars in Excel by **~Earl Grey~** » Tue Sep 29, 2009 12:16 pm

If I saw the code I might be able to help, but I don't know how to access the macro code in Excel.

I was going to say it might be something to do with signed/unsigned integers, but that would make -1 be interpreted as 32768 I think...

PostRe: Scrollbars in Excel by **rogwilco** » Tue Sep 29, 2009 2:43 pm

Thanks for the help EG but I figured it out. Basically scrollbars cannot output negatives so I used a hidden cell with the basic formula of =20-A1. that then gave me a range on my scroll bar from -20 to 20.

Yeah I was thinking about an offset, but I wanted to be able to view the code.

Scrollbars in Excel - Sorted

Who is online

Affiliates