How to show different userform based on users screen resolution?

[Waimea]

I have a userform that is to large on screens that are 1920*1080 or below, how can I check users resolution and if it is smaller or 1920*1080 I want to display the small userform?

If it is 1920*1080 or bigger I want to display the normal userform?

 

[dmt32]

Have a look here:http://www.java2s.com/Code/VBA-Excel-Access-Word/Windows-API/Getscreenwidthandheight.htm

and see if code here helps you

Dave

 

[Waimea]

Hi dmt32,

thank you for your reply.

I googled before I wrote my post and I found a similar thread, I was hoping there was a way to get screen resolution in excel and not from the system.

Also, the code you linked doesn't work on 64-bit?

 

[Waimea]

Perhaps there is a way to put the mousecourser at top = 0 and then move it to the bottom right?

 

[dmt32]

Hi,
It was a link I had in my toolbox but never used it myself - Screen sizing not an area I have expertise in excel maybe another can offer you further guidance

Dave

 

[Waimea]

Hi dmt32,

thank you for your reply and for your link!

I will keep looking for a solution!