checkbox or option box to disable cell

**hitch35** · 06-01-2011, 11:12 PM

Hello all. First off I want to thank the forum--for almost a year now this has been a place I've found a ton of help as a new user. I appreciate all of the work that goes into helping anyone and everyone (beginner, advanced and otherwise).

Question
I've included an example. my spreadsheet is a gpa calculator. In one section there are two course groupings listed (only ONE is to be included in the gpa calculation).

When the user selects a checkbox (group 1 or group 2), I would like the opposing course group to be cleared (just the "letter grade attained" column) of any value and disabled (so the user can't put a value into the opposing course group).

I feel like this could be done with something simple like

IF checkbox is true then value is 0 and locked is true
else if locked = false

If anyone has any input it would be greatly appreciated...

IF you decide to help and can try to explain to me (briefly of course) how and why it doesn't work my way and needs to be another way that would be amazing...

Thank you in advance, sorry for the novel.
-Eric (a student willing to learn)

*Note - checkbox (not sure whether it should be an activeX Control form) would be right beside the titles "Group 1" and "group 2".

In a perfect world -Removing the course group that is disabled from the GPA calculation isn't neccessary but it would be ideal...

Level 5 - Add'l Req: Take 1 of the following Groups:

Group 1

course name / course code / hours per week / letter grade attained
xx xx 3 d
xx xx 3 d
OR
Level GPA
Group 2

xx xx 6 d

**jeffreybrown** · 06-01-2011, 11:16 PM

How about telling people this is a cross post which is in the forum rules.

Please take a few minutes and read the Forum Rules about cross posts.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post

**hitch35** · 06-02-2011, 02:28 AM

I see a few views but no response yet. If I can clear something up please let me know!!!!!

**royUK** · 06-02-2011, 02:32 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this