Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2015, 10:57 PM
Raza Raza is offline Result Calculator Windows 7 32bit Result Calculator Office 2013
Novice
Result Calculator
 
Join Date: Jan 2015
Location: Pakistan
Posts: 14
Raza is on a distinguished road
Default 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
File Type: xlsm Book1.xlsm (22.9 KB, 10 views)
Reply With Quote
  #2  
Old 01-24-2015, 12:58 AM
gmayor's Avatar
gmayor gmayor is offline Result Calculator Windows 7 64bit Result Calculator Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
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

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
Reply With Quote
  #3  
Old 01-24-2015, 02:11 AM
Raza Raza is offline Result Calculator Windows 7 32bit Result Calculator Office 2013
Novice
Result Calculator
 
Join Date: Jan 2015
Location: Pakistan
Posts: 14
Raza is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 01-24-2015, 02:37 AM
gmayor's Avatar
gmayor gmayor is offline Result Calculator Windows 7 64bit Result Calculator Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
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
  #5  
Old 01-24-2015, 03:50 AM
Raza Raza is offline Result Calculator Windows 7 32bit Result Calculator Office 2013
Novice
Result Calculator
 
Join Date: Jan 2015
Location: Pakistan
Posts: 14
Raza is on a distinguished road
Default

your Example is simple. for that I know, there is no need of userform.
Have a look at my one..
Attached Files
File Type: xlsx Example.xlsx (16.0 KB, 11 views)
Reply With Quote
  #6  
Old 01-26-2015, 05:16 AM
Raza Raza is offline Result Calculator Windows 7 32bit Result Calculator Office 2013
Novice
Result Calculator
 
Join Date: Jan 2015
Location: Pakistan
Posts: 14
Raza is on a distinguished road
Default

What happened?
why did you stop answering?
Reply With Quote
  #7  
Old 01-26-2015, 05:38 AM
gmayor's Avatar
gmayor gmayor is offline Result Calculator Windows 7 64bit Result Calculator Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
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 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
Reply With Quote
  #8  
Old 01-26-2015, 11:35 PM
Raza Raza is offline Result Calculator Windows 7 32bit Result Calculator Office 2013
Novice
Result Calculator
 
Join Date: Jan 2015
Location: Pakistan
Posts: 14
Raza is on a distinguished road
Default

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.

Please check the first thread deeply once again
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combinations calculator in excel??? Macro?? mkuderik Excel Programming 1 01-27-2015 11:04 PM
Excel eBay Fee Calculator Formula rdonovan1 Excel 1 09-10-2012 07:37 PM
Result Calculator How can I get the conditional result? Learner7 Excel 1 02-02-2011 03:16 AM
Excel Calculator Mandusin Excel 6 12-25-2010 07:34 AM
Age Calculator in MS Outlook 2002 SP3 turns Outlook 0 06-15-2010 12:26 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft