Group option oval buttons

[Rocky2013]

Hello,
I am looking for help on VBA to have (3) oval option form buttons that are in group.
Click any button, the oval button will be filled in black and line color in black.

Click a different button, it will be filled in black and line color in black. The shape was clicked
previously will change filled to white and line color to dark pink.

See attached Excel file.

Thanks

[6StringJazzer]

Is there a reason for the formatting you want instead of just using standard radio buttons? Your problem will require a bunch of code but could be done in a minute using standard radio buttons, and with no code.

[Eastw00d]

Why don't you use the code I sent in another post? And adapt it a little.

https://www.excelforum.com/excel-pro...-to-black.html

Cheers
Erwin

[Rocky2013]

Hello,
The form I want to duplicate has oval shape, I try to match that using in Excel. I search I found I had a code to group the oval buttons,
but I can not figure out how to specify user's linked cell position. The code seems specify column J, do not understand the code where
row number is specified. I want to specify the linked cell where I want to be located.

Sorry for that, I should look first.

Thanks

[Eastw00d]

This is where your number is going:

Please Login or Register  to view this content.

10 is for column "J' and grpNumber is the groupnumber of the shapes in your worksheet,
but you can change that to your own idea.

Cheers
Erwin

[Rocky2013]

Hello Eastwood,
I played around with changing group number and column to place where I want
the linked cell to be. It works so I am OK with this now.

Thanks again