+ Reply to Thread
Results 1 to 6 of 6

Question about screen resolution

Hybrid View

  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
    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!

  4. #4
    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 …

  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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,377

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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. 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