
October 10th, 2003, 07:47 PM
|
 |
Application is what Divides Us
|
|
Join Date: Dec 2002
Location: Titusville, FL
|
|
|
Is Cell Empty Macro for Excel...
I don't know anything about VBScript except that you can create your own macros for Excel. I don't know any of Excel's functions to create a macro even if I knew VB..
I have an excel file that I created that is set up to find an average for my grades. I would like the macro to check to see if a certain field-the field which tells my exam grade-is empty or not..
if it is, then a seperate function calculates what I need to make on my exam to make an A, B, C, so on and so forth.. the file is attahced and you will probably understand better if you view it for your self...
once you've viewed the file you will notice that the cell B14 is labeled exam and C14 is where the numeric grade would go..
to the right of the provided grades there is a function at work..
a function which calculates what I would need to score on my exam to make a A, B, C, so and so forth in that class..
and below that would be a field which says Taken Exam?:
and F10 after a number being added to the C14 cell would display yes because my exam ws taken, and no if C14 is blank
i hope that you understand what I am trying to accomplish here..
any help or a complete code would work just fine...
__________________
Download [ Fx | Op ] Validate [ Markup | Css ]
Last edited by jsKid : October 10th, 2003 at 07:51 PM.
|