Hi guys & gals,
I made a userform to calculate the net weight of a package by taking the gross weight and deducting the amount of boxes included in the package. The most boxes possible is 25, so I used 25 command buttons numbered 1 to 25, so users only have to press the desired amount of boxes for the calculation to begin. But that also means I've got 25 subs containing the same formula, and that's a bit much. I'm pretty sure this could be done more efficiently, but I'm not sure what's possible, me not being a VB kind o' guy...
I included the sheet, so if anybody has a better way of doing this, it would be appreciated!
Bookmarks