I apologize for what is probably a stupid question but…
when I add a checkbox to Excel it behaves oddly. Clicking on the box does not check or un-check it. It highlights it for editing.
How do I change this behavior so that clicking the box checks or un-checks it?
I assume that you used the button option on the Control Toolbox to create the button. Did you remember to jump out of design mode by clicking the first button (the one with the triangle and ruler icon)? That’s probably your problem.
Hmmm. This is counter to what I’m experiencing in Excel at the moment. If I add a checkbox and then exit design mode, it sets and clears normally. Perhaps you’re not exiting design mode?
If you reply with the exact steps you’re taking that cause this, perhaps I can offer more suggestions. You should also post the version of Excel you’re using, and also note which platform (Windows or Mac) it is.
The following is a bit off-topic, and not directed at the OP, but I think it could help everyone:
I see an emerging standard for tech support questions posted to forums. This standard has been motivated by the explosive growth of open-source software, which is primarily supported by a community of developers:
[ul]
[li]Use a simple statement of the problem as your thread title: “Checkboxes don’t work right in Excel”[/li][li]State your platform[/li][li]State which version of the platform (Windows XP Service Pack 2)[/li][li]Give a complete statement of the problem: “When I create a checkbox in a worksheet and then try to click it, it opens it for editing instead of setting or clearing it”[/li][li]List the steps to reproduce the problem.[/li][li]List error messages in their entirety. Be ready to post/e-mail error logs.[/li][li]List any documentation you’ve read.[/li][li]List any steps you’ve tried to fix the problem.[/li][li]If you get a reply that works for you, post a response and tell everyone.[/li][li]If the advice you get doesn’t work, post a polite reply saying that it didn’t work, and be specific.[/li][/ul]
Some things not to do:
[ul]
[li]Don’t ask for a personal e-mail. Responders may not want to do that, and you’re shutting everyone else out of reading the solution.[/li][li]Even if it is urgent, don’t say you need the fix ASAP. You’ll get it when you get it.[/li][li]Don’t be rude or argumentative, even if you get flamed. Just walk away.[/li][/ul]
Some things to remember:
[ul]
[li]Respondents are using their own time to learn about the product and help you as well. Be considerate.[/li][li]Very few programs are intuitive or easy to use. You have to do some reading and learning to get all the ins and outs. If a respondent tells you to read something, read it. They’re not blowing you off; they’re trying to be efficient with their time and with yours.[/li][li]Try the help first, and also try reading online. Microsoft software is not always easy to use, but their help is darn good and their website is first-class (IMHO). Particularly with error messages, do a search on the program’s web site. This goes double for error numbers.[/li][li]If something doesn’t work the way you think it should, first read the online help or documentation to see how it’s supposed to work.[/li][/ul]
<mod>
Nice concise list, 633squadron.
I’ve copied that in a sticky for this forum. Good advice.
</mod>
Yep - I was in design mode - thanks everyone!
If I can ask a follow up question…
Is there a way to anchor a checkbox to a cell so that if I sort by the column the check boxes are in I can get the checked items at the top?