I have a user form which allows the input of test results quickly.
One box is for a percentage result. If "60.23" is typed in, it will divide this by 100 and then input that into a cell in a work sheet to give 60.23%.
Is it possible for it to do this, but also allow the user to type in:
"60.1, 62.4, 59.5"
So it will scan all three values, calculate an average and then divide by 100, and input into a cell?
Mainly in the interest of saving space, I'd rather do this in one box rather than making three separate boxes
Bookmarks