• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Form Resize according to Window Size

Dear all,


Can anyone help me with a VBA code to resize VBA form (in Excel) according to the screen size which may differ from PC to PC?


Also I have one more requirement:


I have designed a form in Excel and I don't want Excel to show up even in a minimized mode. I just want Form to appear and Excel to run in the background. Is this possible?


Thanks for all your efforts.


Regards,

Ramnath
 
Dramnath1981


Have a look at this site:

http://www.andypope.info/vba/resizeform.htm
 
Hui,


Thanks a lot for your usual support.


Just one quick question. Will this code dynamically adjust the form size according to screen resolution or it will provide a handler to drag as we like?


Regards,

Ramnath
 
Back
Top