[ms office - 2010] VBA in Excel to control cell value

[kirchie]

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

[pcstru]

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.

 

More Info.

Edited October 13, 2012 by pcstru

[kirchie]

Well that WAS simple! Thank you very much pcstru!