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)
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)