I want to place new position for the frame by VBA code but instead ,width of frame increase and doesn't move.
Any idea to solve this problem
I want to place new position for the frame by VBA code but instead ,width of frame increase and doesn't move.
Any idea to solve this problem
its because your frame contains controls - the constrain on the frame is that these controls cannot be outside the frame - so you need to move these as well. Alternative is to put the frame into a subform and move the subform - as you have found, moving the frame does not move the controls - as happens when in design mode
Thank you. I am going to place that than other control in main maximized form and it needs to change size of all controls depends on user monitor. If I put into a subform what do I change size of buttons and frame. Thus I think it's better we find a way to solve this problem.
how much do your users monitors vary in size? Usually easiest to design to the smallest monitor.
There are plenty of examples on this and other forums about resizing forms to fit monitors - here is an example with links https://www.devhut.net/2017/09/08/ac...en-resolution/