Forum Discussion
Checkbox code that works across versions
I have a spreadsheet that has a code that calculates based on boxes that are checked. Unfortunately, depending on what version of Excel you have, it doesn't work so I have one coded differently that ...
mathetes,
Thank you for spending so much time looking at my sheet and providing some great feedback! It's kind of hard to comprehend everything that is going on without context, but the spreadsheet works synonymous with the information they collect with a school program, hence the entry and median salaries. They do research on college and careers and ultimately pick one out to take on a test drive for "real life" while making decisions for housing, transportation, groceries, etc.. It's audience is junior and senior high school students so we are trying to make it look as uncomplicated as possible, while still providing all of the information they need to move onto the next part of the program. I am always open to ideas! I like your second idea and will have to look into that when I have more time. I would say I am a proficient beginner, so these forums (and your feedback) have been really key in my learning.
All that being said, the code you provided at the bottom of your comment is exactly what I am looking for right now, however, when I plug it in on my computer with the newer version of Excel, it doesn't work. 😞 Any other ideas?
Thank you for spending so much time looking at my sheet and providing some great feedback! It's kind of hard to comprehend everything that is going on without context, but the spreadsheet works synonymous with the information they collect with a school program, hence the entry and median salaries. They do research on college and careers and ultimately pick one out to take on a test drive for "real life" while making decisions for housing, transportation, groceries, etc.. It's audience is junior and senior high school students so we are trying to make it look as uncomplicated as possible, while still providing all of the information they need to move onto the next part of the program. I am always open to ideas! I like your second idea and will have to look into that when I have more time. I would say I am a proficient beginner, so these forums (and your feedback) have been really key in my learning.
All that being said, the code you provided at the bottom of your comment is exactly what I am looking for right now, however, when I plug it in on my computer with the newer version of Excel, it doesn't work. 😞 Any other ideas?
I don't know why that formula wouldn't work on the newer version if it works on the older.
But maybe there's a cell reference or some other easily overlooked nit that throws off the whole thing. What I'd suggest to de-bug it is take each of the sub-conditions (if I can call them that)--each condition that needs to be evaluated--and run them individually in the cells where the whole has to work. My guess is that one or more of them is messing things up.
But maybe there's a cell reference or some other easily overlooked nit that throws off the whole thing. What I'd suggest to de-bug it is take each of the sub-conditions (if I can call them that)--each condition that needs to be evaluated--and run them individually in the cells where the whole has to work. My guess is that one or more of them is messing things up.