Thread: [Solved] Result Calculator
View Single Post
 
Old 01-24-2015, 02:37 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
I assumed that may be the issue, but it doesn't explain how your userform will be helpful.
As there is only one set of data in the worksheet, and it is arranged in a column instead of the row that might be helpful if accompanied by other students results, it is difficult to see where you are going with this.
What you need is a row for each student and then you can put the function in Column 5 (with some modifications) and drag to fill the column (or use autofill as in the attached) and set the values.
Attached Files
File Type: xlsx Example.xlsx (8.7 KB, 8 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote