Get a UserForm CheckBox to show a "1" in a cell when checked.

[Niccii]

Good morning!

I've created a Data Entry form with a form checkbox.

The table cell in which the data will be entered for this checkbox has formatting to generate a wingding check mark when the number "1" is entered into it. I want to get the checkbox to report as "1" or "" for the traditional True or False entries so that the check mark will show in the table when the box is checked, and remains blank when not checked.

The code I'm using was copied from another site, and I'm trying to make it work for my needs, but I'm not skilled at this yet and am not sure how to attack it.

I'm hoping you can help me change this code to operate as such. I'll attach screenshots to hopefully better illustrate what I'm looking to do.

Capture.PNG

Capture1.PNG

Thanks!

Please Login or Register  to view this content.

[nigelog]

Please Login or Register  to view this content.

[dotchiejack]

Don't use AddItem to fill listboxes, it's a very slow method.
Use lists.
I rewrote your code.
That is all you need.

Please Login or Register  to view this content.

See attached.