Open Userform in Fullscreen mode

[HOGAN2023]

Hello,

I use 3 monitors in Windows extended desktop configuration (2x 24" and 1x 15" laptop screen).

By positioning the userform on 1 of the 3 monitors, how do I get it to open in fullscreen mode?

Is this possible using API?

I'd really appreciate your help

Thanks,
Vincent

 

[Skyybot]

This may point you in the right direction.

vba to find Screen size in 64bit environment

Hi all. Can someone show me how to get the screen metrics when using a 64bit version of Excel i.e. where do I use "long" and where do I use

www.mrexcel.com

 

[HOGAN2023]

Thanks for reply @Skyybot but but i'v already tried that

 

[Skyybot]

Maybe this one?

VBA Determining Screen Resolutions of BOTH Monitors of a Dual Screen setup

Hi there - here is something that no-one seems to be able to do: I am trying to get the screen resolutions on a dual monitor setup in Excel 2002. GetSystemMetrics32(X) gives me some info, as follows - when X is: (measurements in pixels by the way) 0 - I get the width of the primary monitor 1...

www.mrexcel.com

 

[HOGAN2023]

Maybe this one?

VBA Determining Screen Resolutions of BOTH Monitors of a Dual Screen setup

Hi there - here is something that no-one seems to be able to do: I am trying to get the screen resolutions on a dual monitor setup in Excel 2002. GetSystemMetrics32(X) gives me some info, as follows - when X is: (measurements in pixels by the way) 0 - I get the width of the primary monitor 1...

www.mrexcel.com

I knew about this approach but unfortunately, the 2 URL links in this post are dead