VBA square option buttons with check marks

Hello,
I try to make option buttons instead of round with a black dot but square box with check mark
liked the check box. Box can be filled with color (light blue or other color). When the box is picked
the fill change to white background.

I have 5 option boxs, I like to group them in one group because I have other groups using the
option boxs. I want the check mak stayed in that group when it is picked.


Thanks

Create a frame box and Keep all the check boxes inside the frame

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

This will not match regular UI design. However you may assign this code to your checkboxes - based on the names in your sample workbook:

Please Login or Register  to view this content.

Hi Izandol,
Thanks for the code. I am not sure how this work. What I did is to modify the sample
to show only one style. I also rename the check box to 1, 2, 3, 4, 5. However I could not
change one of the check box 13 to Check Box 3. I use the name list from upper-left to rename.

Could please modify the attachment. Basicly Iwhat I need is to create option button using check
marks in a square box liked the check box. Then I group the check boxs from 1 to 5.


Thanks

Here is modified attachment.

Thanks. It works but ...

1. How can I have all shaedd check boxs start without any check marks?
2. How to shaded and unshaded the boxs?
3. How to change the shade color? Box will be filled in light blue R:220, G:230, B:241
4. How to uncheck the box which already has a check mark to return to a shaded box without check mark?
(e.g., click once to add check mark without any shade, click again to uncheck with shaded box)
5. Is that possible to have a shaded checked box with a check mark, once the mouse pointer move away fron the check box? (nice to have) **
6. How do you change the box 13 to box 3? (lession & learn)



Your code looks very simple. I could not figure out how to unshade the box and change the shade color.
I make it more complicate which I did not see at the beginning until seeing in action.

I am very appreciate your help.

Regards,

Rocky2013

It is not possible to change shade colour.

You must set Value to Mixed.

I will suggest you use a button to uncheck all checkboxes. It will be much simpler.