Assigning Settings to a Scrollbar (Form Control)

[JP777]

I am trying to assign certain max, min, incremental settings, and cell link to a scrollbar I have put on a worksheet. As this scrollbar is clicked, it should step through time at certain steps, and the cells on that same work sheet, as well as a chart, will be updated with each click of the scrollbar. I tried the below code but got an error every time I clicked the scrollbar saying "Object variable or With block variable not set":

Please Login or Register  to view this content.

I have also tried this, but got absolutely nothing:

Please Login or Register  to view this content.

Any suggestions on getting the scrollbar settings assigned? Ideally, I would like to be able to have it start at a value in cell A2 and each increment would be the value of the next cell down (A3, A4, A5, etc.) until the max is reached (A?? - amount of data in column A varies). Thanks for your help!

[JP777]

Here is the sample spreadsheet, if it helps. Thanks

[JP777]

Since I am in a time crunch, I went ahead and cross-posted to another forum. Here is the link:
http://www.mrexcel.com/forum/showthread.php?t=632123

[JP777]

by the way, even though I cross-posted to the other forum, I still haven't gotten my issue resolved. so, if anyone would be willing to help me with this, I'd greatly appreciate it!

updated code (in module 1):

Please Login or Register  to view this content.

when i check my properties after the code is assigned to the scrollbar, my min value and both increment values go to zero, but my max value is correct. Any ideas? Since i've had such difficulty, I tried an ActiveX scrollbar, but ran into the exact same problems. Here is my code for it in the Sheet3 module:

Please Login or Register  to view this content.

Thanks in advance for any help!

[JP777]

$10 via PayPal to the person who can help me figure out what's wrong with this issue. just private message me the email address on your PayPal account.....in a time crunch, so willing to pay this. The other thread I have posted about scrollbars is worth another $10, since the solution to it would probably cover this solution as well......everyone can use an extra $20, right??

[JosephP]

you can only use integer values

[JP777]

thanks for the feedback, JosephP. Please check your inbox, as well as the other thread you helped me with today. thanks