Hi


sorry for my english!
I made the userform with excel (attechment), it cannot calculate the real result. I don't know why?
Can anybody solve that?
It cannot get the data from Textbox which is mentioned as Passing Marks.

Attached Files

Book1.xlsm (22.9 KB, 12 views)

Your English is not the problem here

What EXACTLY are you trying to achieve, and if it is simply to get the pass/fail indication of the three values on your worksheet, why do you need the userform?

You can achieve that with a function e.g. If you put the pass mark in a cell (here C1) then

=IF(AND(A1>=C1,A2>=C1,A3>=C1),"PASS","FAIL")

in A4 will indicate whether A1 through A3 have met the value in the C1.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Userform for calculating results of 1000 students.
Typing function for each student will be difficult, so this userform helps to calculate just by mentioning the range and passing mark.

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

Example.xlsx (8.7 KB, 10 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

your Example is simple. for that I know, there is no need of userform.
Have a look at my one..

Attached Files

Example.xlsx (16.0 KB, 13 views)

What happened?
why did you stop answering?

I answered as far as I was able. I took one look at your worksheet example and my eyes glazed over.

Attempting to program this would be a nightmare, and frankly I can't see why you have taken that approach. I can't imagine how it would work for more than a handful of students, and you mentioned 1000!

If I was doing it I would have created a worksheet with one row per student, and columns for the data you wish to record (much like my earlier example).

I would have added a VBA userform to the workbook which would reproduce the input requirements for a single student (much as you have it on the sheet itself). The data for each student (each iteration of the form) is added to the next available row of the worksheet.

This then gives you a data source that you can employ for a variety of purposes.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Ok let us come back to my question.
is there any way to catch the textbox value from the userform, in order to calculate the result?
Check Out the above excel file in first thread.
I want must be fail.

Please check the first thread deeply once again