#1
|
|||
|
|||
Mutually exclusive checkboxes with text
Hi everyone,
I'm trying to create an evaluation form in Word, and have run up against a coding issue that I hope someone here can help with. Here goes: I have a table, and within that table there are six checkboxes, each in a separate cell. We want these to be mutually exclusive for reasons of scoring. A seventh cell should display a score based on which checkbox is selected. This setup occurs for multiple criteria, then at the bottom the combined criteria scores are tallied. So, first things first. I found code on Microsoft's web site that works perfectly for making the checkboxes mutually exclusive in sets, so I'm OK with that. Further, I know how to create a SUM field to tally the scores once they are in place. It's getting a score to show based on the box selected that has me stumped. I've searched all over the web and spent several days trying various IF/THEN formulas and macros, but haven't gotten any to work. In short, what I want is this: a user checks box 6, and the score "6" appears in the seventh cell. If they change and mark box 5, the score changes to 5, and so on. I'm sure I'm missing some very easy, but since I'm a noob at VBA, I come hat in hand to ask the experts. Any ideas how I can connect the check boxes to a score for easy calculation? Any help and assistance is appreciated! UPDATE: Here is one code I found, but I receive a "424" error when I attempt to run it. Sub CheckBox1_Change() If CheckBox1.Value = True Then TextBox1.Text = "Checked!" Else TextBox1.Text = "Unchecked." End If End Sub |
#2
|
||||
|
||||
See the thread - https://www.msofficeforums.com/word-...t-counter.html
However I am not sure how well this will lend itself to the Mac version.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thanks
gmayor,
Thanks! I'll give this a shot. If I hit another snag, I'll definitely give you a shout. You seem to know what you're doing, unlike me! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
checkboxes | smohap | Word | 1 | 06-19-2011 09:24 PM |
using checkboxes to delete tables | atfresh | Word Tables | 1 | 06-19-2011 09:13 PM |
Excel Checkboxes | theresamille699 | Excel | 3 | 04-12-2011 08:08 PM |
Ticking Checkboxes | screid | Word | 1 | 06-08-2010 02:04 AM |
Manipulating checkboxes in XML | Ivo | Word | 0 | 12-06-2005 09:04 AM |