I have made for a Userform to make things easier for the users. I have noticed that I have sized the userform to fit a 22 inch desktop screen but it won't fit on laptops and smaller screens.
Is there a way so that the userform always fits the screen?
I appreciate beforehand your attention and time.
Thank you
Kirana.
Last edited by kirana2014; 11-29-2016 at 02:15 AM.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=32
That should help, but I would suggest setting a static Userform size that will work on all resolutions instead of making one dynamic.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi kirana2014,
You can use 'ActiveWindow.Height' or 'Application.Height' to determine the maximum visible UserForm height. If the UserForm is larger than the 'maximum visible height', you can add ScrollBars to the UserForm.
See the attached file which includes UserForm MouseWheel code (32 bit Excel only) at no extra charge. For additional UserForm MouseWheel code see post #23 associated with: http://www.excelforum.com/excel-prog...orm-frame.html
Lewis
Please Login or Register to view this content.
Daer Lewis,Mike,
Thank you so much for your attention and time.
Dear Lewis,Mike,
Thank you so much for your attention and time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks