Check Boxes

[AllenCochran]

I have a long list of items that I need to check. On the last version of this document, good = 1, bad = 0, piece of cake. On the new version, I have been instructed to make good = a check mark and bad =no check mark. My total score is then is caculated from there.

I used the activeX control and it was working fine (other than the pain of having to do each manually) and then my file size got to large. It was crippling excel and I have a good computer.

Any suggestions.

 

[pedro-egoli]

Try this, if you want a tick in box alongside the "good" and "bad"
Highlight the column you want the tick to appear

Change font for that column to "Marlett"
Use this formula, assuming column A has the results.

=IF(A1="good","b","")

Pedro

 

[PCRIDE]

Try not using the Active X controls, just use the regular ones.

 

[AllenCochran]

Pedro,

That was a cool function and will definitely be used in other worksheets, but I don't think I was clear enough with my current problem. I want the user of this form to easily be able to toggle a check mark. I do not want them to be required to type (or pull from a drop down) the words "good" or "bad". I should have said "true" or "false".

Column A is the check mark column. I need a way to generate a score based on whether or not a check mark is checked or not.


PCRIDE,

Which other check boxes are you referring to? Please see me respone to Pedro above.


I appreciate all help.

Thanks