[RESOLVED] Where is screen class?

**marktheman** · Mar 28th, 2007, 06:02 AM

Hi,
I'm trying to set user forms up so adjust to the current screen resolution. I know how to do this using the following code.

Code:

frmSearch.Move (0,0,screen.width,screen.height)

Just wondering under references in VBA where the screen module.
Thanks.

**RobDog888** · Mar 28th, 2007, 06:16 AM

No screen module or class. Either use APIs like the GetSystemMetrics passing the SM_CXSCREEN or SM_CYSCREEN arguments or just get the size of the ap window with Application.ActiveWindow.PointsToScreenPixelsX etc.

**marktheman** · Mar 28th, 2007, 08:42 AM

Cheers, that API call worked. Thanks.

**RobDog888** · Mar 29th, 2007, 04:24 AM

Np, glad to help.

Ps, dont forget to Resolve your thread now that its solved so other members will know its answered.

Thread: [RESOLVED] Where is screen class?

Thread Tools

Display

[RESOLVED] Where is screen class?

Re: Where is screen class?

Re: Where is screen class?

Re: Where is screen class?

Posting Permissions