+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    kirchie's Avatar
    Join Date
    Jul 2012
    Location
    Oxfordshire
    Posts
    83
    Thank Post
    16
    Thanked 6 Times in 6 Posts
    Rep Power
    6

    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

  2. #2


    Join Date
    May 2009
    Posts
    2,878
    Thank Post
    258
    Thanked 767 Times in 582 Posts
    Rep Power
    269
    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.
    Last edited by pcstru; 13th October 2012 at 10:20 AM.

  3. Thanks to pcstru from:

    kirchie (13th October 2012)

  4. #3
    kirchie's Avatar
    Join Date
    Jul 2012
    Location
    Oxfordshire
    Posts
    83
    Thank Post
    16
    Thanked 6 Times in 6 Posts
    Rep Power
    6
    Well that WAS simple! Thank you very much pcstru!

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2010] how to change the data values in excel
    By meadowgirl in forum Office Software
    Replies: 0
    Last Post: 14th September 2012, 12:16 PM
  2. [MS Office - XP] Excel Macro - If Cell Value
    By ahuxham in forum Office Software
    Replies: 0
    Last Post: 18th December 2009, 10:27 AM
  3. VB code to colour cells in a word table
    By park_bench in forum Coding
    Replies: 4
    Last Post: 30th June 2008, 08:52 AM
  4. Excel Not Recognizing Cells of Equal Value
    By G_Money in forum Windows
    Replies: 2
    Last Post: 21st June 2007, 08:33 AM
  5. need to extract text from a string in excel
    By projector1 in forum How do you do....it?
    Replies: 7
    Last Post: 14th February 2007, 01:41 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •