Forum Discussion
Misha_Zainab100
Jan 19, 2022Copper Contributor
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 change the order of my table from largest to smallest the checkbox doesn't move with it
Largest to smallest number, checkbox is shifted down and now I have lost my pattern.
Can anyone help with this please?
- NikolinoDEGold Contributor
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_Zainab100Copper ContributorIs there a quick way of fixing this or do I have to do one by one I have almost 600 entries in my file where I used form control and I need to convert it to Xcontrol
- Misha_Zainab100Copper ContributorHi Thank you so much I think I have solved it by using active Xcontrols you have been a great help 🙂
- KSoreeCopper Contributor
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
- Misha_Zainab100Copper ContributorThank you NikolinoDE, I want the checkbox to move with the cell but keep the order and I noticed my option for move and size with cell is disabled (greyed out) ;(
- Misha_Zainab100Copper Contributor