Forum Discussion
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 ...
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)
Thank 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) ;(
- I am glad that you can make progress in your project.
I wish you much success and fun with Excel.- One last think how do I lock it so no one can change it after I have ticked the right boxes?
It is always an advantage (for you and for the helpers) if the Excel version, operating system, storage medium is known in advance :).
A file (without sensitive data) would also help.
Maximum size: 71 MB • Maximum attachments allowed: 5It's also not known if it's a form control or an ActiveX control...or an image.
If it's Excel for the web...
Add a check box or option button (Form controls)
Thank you for your patience and understanding