Forum Discussion

Copper Contributor

Feb 14, 2022

Checkboxes shifting when opened on smaller laptops vs. larger laptops and monitors

I have been working on a semi-complex form in excel. The form includes checkboxes, drop-down selection lists, fillable fields, etc... I use a Dell Precision 15 inch, my coworker uses a Dell Inspiron ...

developer

Formulas and Functions

NikolinoDE

Gold Contributor

Feb 14, 2022

nrackerman

Enable developer tools in advance

ALT+F11 VBA opens

Click draft mode

Go to the box with the right mouse button.

Format Control-->Properties tab-->Depend on cell position and size.

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

nrackerman

Copper Contributor

Feb 14, 2022

NikolinoDE

Thank you for sharing this, I gave it a shot, but sadly no luck. I am still experiencing the issue of the checkboxes shifting over.

NikolinoDE
Gold Contributor
Feb 15, 2022
nrackerman
With your permission, if I may recommend, provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
What I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.
Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5

Don't forget that not every Excel user has a clue about every job and that what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE
I know I don't know anything (Socrates)