Forum Discussion
Checkbox to move with sort
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)
- Is 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
- Hi Thank you so much I think I have solved it by using active Xcontrols you have been a great help 🙂
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
- 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.
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
