Excel 2003 visual basic for 'spinbutton'
i'm experimenting with 'spin buttons' and want each click of the button to
display an array of cells from another sheet .e.g click 1 displays A1:G15
from sheet1 and displays in sheet2, next click dislpays A16:G31 and so on. In
other words 'scrolling'
I can get it to work once but for the first click but not the second click.
What is the secret to the second, third etc. click to get the function i
require?
Am i using the correct button?
Ahhhhhh!
--
Browny
|