How to Sort this SpinButton Prob in UserForm????

[nyk911]

I have userform to enter data and the worksheet. There are 21 textboxes and command buttons which are perfectly fine.
The problem im facing is with 2 spinbuttons which scrols through the entered data and also populates the respective textboxes in the userform. Those 2 spinbuttons are with different small-change value as i deal with about 5000 (rows).

SpinButton1 with small-change value of 1
SpinButton2 with small-change value of 1000

What i want is that when scroll SpinButton2 and jump from row1 to row1000, and use SpinButton1.....
i want it to start from where spinbutton2 rested.

(If I use SpinButton1 after After SpinButton2,,,,The SpinButton1 Active Cell to start with Cell where SpinButton2 rested)

 

[Domenic]

Have you considered using a ScrollBar instead? The ScrollBar has both a SmallChange property and a LargeChange property. So you could set the SmallChange property to 1 and the LargeChange property to 1000.

 

[nyk911]

Hello Dominic,

Thanks for your prompt reply. I would like to mention that my process is to populate the info from the worksheet to the textboxes in the userform. There will be around 5000 rows that i will scroll through and edit then save. These will be done using the spinbuttons and commandButton.
First spinbutton will spin each row by row. (small-change value of 1)
Second spinbutton will spin by jumping to next thousand rows. (small-change value of 1)

My prob is that.... if i want to edit row-2008, then i click spinbutton2 twice to get to the row-2000 and click spinbutton1 but it does not start from row-2000... it starts from where ever it was resting earlier.

Thank you so much for the support!!!!!!

 

[mikerickson]

A scroll bar could do that.
If you insist on spin buttons, code like this will link them.

Private Sub SpinButton1_Change()
    SpinButton2.Value = SpinButton1.Value
End Sub

Private Sub SpinButton2_Change()
    SpinButton1.Value = SpinButton2.Value
End Sub

 

[nyk911]

Thank you Mikerickson,
I'm checking with the code..... and will update u now.

 

[nyk911]

Mikerickson,

NAILED IT...!!!!!!!

Thank you so much for your help!!!!