xfr79
01-02-2009, 09:31 AM
First off, this is a cross post at http://www.mrexcel.com/forum/showthread.php?t=361806&highlight=spin+button+scrolling+lookup+reference .
I will mark as solved if it's solved at other forum.
I have a couple spin buttons in my worksheet.
What I want each one to do is to scroll through cell links.
For example, cell I4 has a lookup reference of "=LOOKUP(2^20,Sheet3!A:A)". What that does is get data from the very last line on sheet3 column A.
What I want the spin button to do is scroll through the lines in column A.
So if a user decided he/she did not want that data from column A, then all they would have to do is press up or down on the spin button , scrolling through other data that is in column A.
cell lookups:
I4 - =LOOKUP(2^20,Sheet3!A:A) <--- Date
B3 - =LOOKUP(2^20,Sheet3!B:B) <--- Number
B4 - =LOOKUP(2^20,Sheet3!C:C) <--- Number
B5 - =LOOKUP(2^20,Sheet3!d:d) <---- Date
thanks for taking a look!
I will mark as solved if it's solved at other forum.
I have a couple spin buttons in my worksheet.
What I want each one to do is to scroll through cell links.
For example, cell I4 has a lookup reference of "=LOOKUP(2^20,Sheet3!A:A)". What that does is get data from the very last line on sheet3 column A.
What I want the spin button to do is scroll through the lines in column A.
So if a user decided he/she did not want that data from column A, then all they would have to do is press up or down on the spin button , scrolling through other data that is in column A.
cell lookups:
I4 - =LOOKUP(2^20,Sheet3!A:A) <--- Date
B3 - =LOOKUP(2^20,Sheet3!B:B) <--- Number
B4 - =LOOKUP(2^20,Sheet3!C:C) <--- Number
B5 - =LOOKUP(2^20,Sheet3!d:d) <---- Date
thanks for taking a look!