Microsoft Office Forums Result Calculator
 Register FAQ Search Today's Posts Mark Forums Read

#1
01-23-2015, 10:57 PM
 Raza Windows 7 32bit Office 2013 Novice Join Date: Jan 2015 Location: Pakistan Posts: 14
Result Calculator

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, 10 views)
#2
01-24-2015, 12:58 AM
 gmayor Windows 7 64bit Office 2010 32bit Expert Join Date: Aug 2014 Posts: 4,075

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
#3
01-24-2015, 02:11 AM
 Raza Windows 7 32bit Office 2013 Novice Join Date: Jan 2015 Location: Pakistan Posts: 14

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.
#4
01-24-2015, 02:37 AM
 gmayor Windows 7 64bit Office 2010 32bit Expert Join Date: Aug 2014 Posts: 4,075

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, 8 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
#5
01-24-2015, 03:50 AM
 Raza Windows 7 32bit Office 2013 Novice Join Date: Jan 2015 Location: Pakistan Posts: 14

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, 11 views)
#6
01-26-2015, 05:16 AM
 Raza Windows 7 32bit Office 2013 Novice Join Date: Jan 2015 Location: Pakistan Posts: 14

What happened?
#7
01-26-2015, 05:38 AM
 gmayor Windows 7 64bit Office 2010 32bit Expert Join Date: Aug 2014 Posts: 4,075

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
#8
01-26-2015, 11:35 PM
 Raza Windows 7 32bit Office 2013 Novice Join Date: Jan 2015 Location: Pakistan Posts: 14

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
Code:
`< Textbox.value`
must be fail.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post mkuderik Excel Programming 1 01-27-2015 11:04 PM rdonovan1 Excel 1 09-10-2012 07:37 PM Learner7 Excel 1 02-02-2011 03:16 AM Mandusin Excel 6 12-25-2010 07:34 AM turns Outlook 0 06-15-2010 12:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top