Forum Discussion

Copper Contributor

Jan 19, 2022

Checkbox to move with sort

Hi I am looking to use a checkbox as a entity in cell and not an object so that when I filter my columns my checkbox option also move for example in below only B2 and D4 is ticked and when I want to ...

excel

NikolinoDE

Platinum Contributor

Jan 19, 2022

Misha_Zainab100

Select - click on Design mode first.

Then right mouse click on the box.
Format Control-->Properties tab-->Depend on cell position and size.

Link-Information: Add a check box or option button (Form controls)

Deselect - click off on Design mode

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)

Misha_Zainab100

Copper Contributor

Jan 19, 2022

Hi Thank you so much I think I have solved it by using active Xcontrols you have been a great help 🙂

KSoree
Copper Contributor
Apr 12, 2023
Misha_Zainab100 Apologies for butting in on this thread. But I was wondering what settings you changed in Active X to get your desired outcome? I'm struggling with the same challenge as you did.

Thanks
Kamil