Please help me on Userform Resize problem

[anupamtiwari05]

Hi All Excel Gurus,

I need your help to resolve my query regarding resize of userform in Excel.


Issue:-

I have designed an Userform which is working best on my laptop however when I am running the same on my PC, its not showing completely just because of different resolution.


I have searched google however could not find the exact answer.


Could you please provide me such code for userform that can make it fit on the screen as per the system resolution.


Thanks and Regards,

Anupam

 

[Hui]

Anupam


When you say user Form are you referring to a Worksheet or a VBA Userform ?


For a Worksheet area setup as a Userform select the area and then zoom to fit selection

 

[anupamtiwari05]

Hi Hui,


Sorry, forgot to clarify that thing, the userform is a VBA Userform where I am having the above mentioned problem.


Thanks & Regards,

Anupam

 

[NARAYANK991]

Hi Anupam ,


Have you tried using the UsableHeight and UsableWidth properties ?


Have you tried the following ?


1. http://www.mrexcel.com/forum/excel-questions/641250-user-form-different-screen-resolutions.html


2. http://www.ozgrid.com/forum/showthread.php?t=91302


Narayan

 

[kaushik03]

Hi Anupam,


Do these links helpful for you?


http://www.vbaexpress.com/kb/getarticle.php?kb_id=32


http://www.xtremevbtalk.com/showthread.php?t=165267


Kaushik

 

[anupamtiwari05]

Hello Narayan/Kaushik,


Thanks a lot for your assistance.


Above links provided could not resolve my problem completely however the above links help me a lot to reach the solution as I have browsed the forum in the above OZGRID link and found the exact solution what I was looking for.


Here is the link that solved my issue:


http://www.ozgrid.com/forum/showthread.php?t=172112


Again thanks a lot for your valuable time.


Regards,

Anupam Tiwari