Results 1 to 2 of 2

Thread: Screen.Width

  1. #1
    Join Date
    May 2009
    Location
    Ottawa, Canada
    Posts
    11

    Unanswered: Screen.Width

    Hello everyone,

    I seem to be having an issue with the code I got from:Auto Size Combo

    Whenever I try and use it, vba doesn't recognize Screen.Width

    The .Width portion being the highlighted area.

    I just get a compile error:
    "Compile Error:

    Method or data member not found"

    Can anyone help me out on this; I don't know why my brain has melted on this probably simple solution.

    P.s This issue is also occurring with the .TwipsPerPixelX attribute.

    Thank you.

  2. #2
    Join Date
    May 2009
    Posts
    258
    Hello rashoku,

    In VBA, there is no Screen object, but you can try using the following instead:
    Code:
    Application.ActiveWindow.Height
    Application.ActiveWindow.Width
    Ax

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •