+ Reply to Thread
Results 1 to 1 of 1

Need some MAC assistance - Image on Userforms wonky

  1. #1
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Need some MAC assistance - Image on Userforms wonky

    I have created a userform for a client and unfortunately they have recently moved to a lot Mac computers and the form I've designed behaves idiotically in the MacOS.

    Specifically, the logo at the top of every form is completely out of whack, and the form itself seems to occasionally be putting itself on the right hand side of their very large screens.

    Bad1.png
    Bad2.png
    Bad3.png

    On my PC, the images are perfect.
    Good1.png

    I found online a reference to MacOS needing all pictures on Userforms to be Bitmap, so I changed the pictures to bitmap. But they still look terrible.

    I own no Mac products so can't resolve these two issues. Is there a way to get these images to look correctly on these many forms and get the form to stay centered and LARGER on Mac screens. It's tiny and sometimes off to the side.


    There are two versions of the forms file you can look at. The regular one just has the "fixed" BMP image, but still is not displaying the correct size on the forms. V1.1

    Then the second version has additional code meant to increase the size of every form by 80% when viewed on a Mac, also reportedly not working.

    Any help here on these image/form placement/form size issues?

    The forms are too big to post here, so I've posted them on my Excel blog.

    https://drive.google.com/a/madrocket...?usp=drive_web
    https://drive.google.com/a/madrocket...?usp=drive_web
    Last edited by JBeaucaire; 10-02-2018 at 10:30 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Time formulas are acting wonky
    By WingnutWick in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 08-15-2018, 11:58 AM
  2. Wonky XIRR Return
    By Drymr in forum Excel General
    Replies: 14
    Last Post: 12-27-2017, 09:20 PM
  3. Replies: 1
    Last Post: 11-14-2017, 11:44 AM
  4. Replies: 4
    Last Post: 01-17-2017, 12:58 PM
  5. Data in Excel 2010 Gets Wonky
    By npaprocki in forum Excel General
    Replies: 1
    Last Post: 01-03-2015, 10:16 AM
  6. UserForms assistance Required
    By newbie13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2008, 01:43 PM

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