View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Browny Browny is offline
external usenet poster
 
Posts: 40
Default 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