Forum Discussion
Solved
Limiting Spin Button and Printing All
Hello Everyone! There's this file I'm working on that I need help on. The two challenges I face now are: 1. The spin buttons I am using usually go beyond their limit and end up spinning to bla...
The spin button is grouped with a command button.
Ungroup them.
Then right-click the spin button and select Format Control... from the context menu.
Set the maximum value to 51 instead of 30000, then click OK.
Finally, group the spin button with the command button again.
The number of students is 52.
The minimum value of the spin button is 0, so you should set the maximum to 51 (0, 1, ..., 51 = 52 values).
Assign the following macro to the PRINT ALL IN SS1 GOLD button:
Sub Button116_Click()
Dim ws As Worksheet
Dim i As Long
Application.ScreenUpdating = False
Set ws = Worksheets("SS1 GOLD")
For i = 0 To 51
Range("I232").Value = ws.Range("B" & 5 + i).Value
Application.StatusBar = "Printing report card for " & Range("I232").Value
Call Macro9
Next i
Application.StatusBar = False
Application.ScreenUpdating = True
End Sub
I actually don't understand the first part. Please elaborate on what addition I should include in the macro.
The second one works perfectly.
Very very grateful 😀😀
The second one works perfectly.
Very very grateful 😀😀
The spin button is grouped with a command button.
Ungroup them.
Then right-click the spin button and select Format Control... from the context menu.
Set the maximum value to 51 instead of 30000, then click OK.
Finally, group the spin button with the command button again.
- It worked! Thanks alot, Sir.