+ Reply to Thread
Results 1 to 6 of 6

Question about screen resolution

  1. #1
    Registered User
    Join Date
    05-25-2023
    Location
    Portugal
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Question Question about screen resolution

    Hello everyone
    I have a question regarding the resolution and zoom of a monitor.
    I am currently doing an Internship in a company and they have asked me to develop an interface in VBA that will be used in the Tear Down area of the company.
    Currently the interface is almost finished,however i am facing an annoying issue.
    The issue that im facing is that i made this interface on my laptop which the resolution of it is 1920x1080 with a zoom of 125% and the monitors that this interface will run on have a resolution of 1360x768 (I know, they are ANCIENT) and every time i open up my program the interface looks kinda meh.
    I wouldn't mind it if the interface wasn't looking that good if it still worked properly,however the main reason im starting this thread is because i have a button in my interface that displays images of where leaks can happen and the user is supposed to click on the spot where a leak occurred and that info will be sent to a cell in the sheet but since the resolution of their monitors are different from the one i used to code the excel file the images aren't displayed correctly and the labels that i assigned to have those values are in different spots.
    Do i really need to get them new monitors or is there a way to fix this?

    Thank you for reading

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Question about screen resolution

    Attach a sample file, so we can have a look, or change your monitor settings to a lower resolution and test things yourself

    May years ago going between 4:3 and 16:9 monitors I did something like the link below
    https://www.makeuseof.com/tag/fit-ex...dsheet-screen/

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Question about screen resolution


    Hello,

    an obvious workaround is to use a worksheet as a form rather than an UserForm …

  4. #4
    Registered User
    Join Date
    05-25-2023
    Location
    Portugal
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Re: Question about screen resolution

    i would attach the file however the file contains information that we cannot share to people on the outside
    ill take a look at the link!

  5. #5
    Registered User
    Join Date
    05-25-2023
    Location
    Portugal
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Re: Question about screen resolution

    well i already spent a week making all the user forms required for this so i REALLY don't want it to go to waste..
    plus the way it is setup now looks much better than it would if it was all on the sheet(i think)

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,978

    Re: Question about screen resolution

    however the file contains information that we cannot share to people on the outside
    Desensitise it with fake dummy data.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with VBA Autofit Screen View to any screen resolution
    By Jalica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2018, 04:10 AM
  2. [SOLVED] Adjust screen resolution automatically to fit all screen sizes
    By Ace_XL in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 08:51 AM
  3. Screen Resolution
    By yonyon7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2007, 12:39 PM
  4. Screen Resolution Question
    By Caligula83 in forum Excel General
    Replies: 1
    Last Post: 10-30-2006, 09:26 AM
  5. Screen Resolution
    By Jason Zischke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2006, 01:40 AM
  6. Can't get screen resolution
    By StevenS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2005, 09:10 AM
  7. [SOLVED] Screen Resolution
    By Ronbo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2005, 10:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1