+ Reply to Thread
Results 1 to 3 of 3

How to resize the Userform based on screen resolution in Office 64bit and Windows 64bit

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    Philippines
    MS-Off Ver
    MS Office 2016
    Posts
    28

    How to resize the Userform based on screen resolution in Office 64bit and Windows 64bit

    Hello everyone,

    Can someone help me fix this code. This code below in my userform is working well on 32bit office/windows but whenever I use the 64bit office/windows
    I always get this error. Technically I only want my userform can be used in either 32&64bit Office/OS.

    Compile error.
    The code in this project must be updated for use on 64 bit
    systems. Please review update Declare statements and then
    mark them with PtrSafe attribute.

    Please Login or Register  to view this content.

    Thanks for any help,

    King
    Last edited by king05; 10-21-2018 at 08:51 AM.

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: How to resize the Userform based on screen resolution in Office 64bit and Windows 64bi

    Hi,
    Try

    Please Login or Register  to view this content.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-27-2016
    Location
    Philippines
    MS-Off Ver
    MS Office 2016
    Posts
    28

    Re: How to resize the Userform based on screen resolution in Office 64bit and Windows 64bi

    Thanks dotchiejack,

    I just added few lines of code in order for the userform to work in either 32&64bit.

    Please Login or Register  to view this content.

+ 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. MonthView Control missing in Office 2013 64bit
    By dhlao in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2015, 08:11 AM
  2. How to read custom props on closed file (64bit Win Server, 64bit Excel)
    By soundneedle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2015, 01:25 AM
  3. SOAP component30 not compatible with Office 64bit
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2014, 03:56 AM
  4. Change registry settings for IE 64bit in 64bit environment
    By dgdgdg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 07:56 AM
  5. [SOLVED] Updating Code for 64bit Office
    By D.A.S in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-22-2013, 06:16 PM
  6. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  7. 64bit XP Pro and Office 2003 excel glitches?
    By LJS in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 12:45 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