Forum Discussion
Lukmanayahayya
Oct 12, 2022Copper Contributor
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...
- Oct 13, 2022
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.
Lukmanayahayya
Oct 13, 2022Copper Contributor
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 😀😀
HansVogelaar
Oct 13, 2022MVP
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.
- LukmanayahayyaOct 13, 2022Copper ContributorIt worked! Thanks alot, Sir.