Office Software Thread, VBA in Excel to control cell value in Technical; I'm making a SS for some teachers that lets them track how the kid's grades are doing compared to their ...
12th October 2012, 10:31 PM #1
VBA in Excel to control cell value
I'm making a SS for some teachers that lets them track how the kid's grades are doing compared to their targets (conditional formatting with a Vlookup on a grade boundary table). They've not asked for the feature I want to include, but I'm going to try it anyway. What I want to do is make a bit of code, or an IF statement if that's simpler, that provides a prompt if the teacher enters a mark that's higher than the maximum (e.g. they put 5 when the top mark is 4). I've got a basic idea of how it should look, something like "IF the value of cell x is greater than y, then do pop up warning", but it's been so long since I've used VBA.
If anyone else has been able to do this or can do this and can shed some light, I'd be eternally grateful
13th October 2012, 10:19 AM #2
Just create a tab called (say) lookups (my favourite tab!). Make a list of valid grades in on that tab. Select the list and in the names box (*1) give the range a name say ValidGrades. Now on the cells where the teacher will enter the grades, select the cells then from the data toolbar select "validation". In the popup select "list" from the dropdown and then in the Source box put "=ValidGrades". The cells will now only allow values in the list you defined.
Last edited by pcstru; 13th October 2012 at 10:20 AM.
Thanks to pcstru from:
kirchie (13th October 2012)
13th October 2012, 05:06 PM #3
Well that WAS simple! Thank you very much pcstru!
By meadowgirl in forum Office Software
Last Post: 14th September 2012, 12:16 PM
By ahuxham in forum Office Software
Last Post: 18th December 2009, 10:27 AM
By park_bench in forum Coding
Last Post: 30th June 2008, 08:52 AM
By G_Money in forum Windows
Last Post: 21st June 2007, 08:33 AM
By projector1 in forum How do you do....it?
Last Post: 14th February 2007, 01:41 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)