+ Reply to Thread
Results 1 to 8 of 8

Form resizer works on my work computer, but not at my home computer.

  1. #1
    Registered User
    Join Date
    07-18-2017
    Location
    evansville
    MS-Off Ver
    2016
    Posts
    5

    Form resizer works on my work computer, but not at my home computer.

    Hi All, I created a Userform and added form resizer code at work, and it works great. When i try to work on it at home, such as updating the form and managing the data.
    The resizer code keeps giving me an error. The error displayed is: Compile error: Type mismatch. I have the same Windows 10 and the same Excel on both computers. I can't seem to understand why it error on my home computer. I marked the error location with underlined text. Any help or possible solutions would be much appreciated.
    Thank You,
    Steve


    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Form resizer works on my work computer, but not at my home computer.

    Hi,

    The error is caused by two lines that reference UserForm1 which is used incorrectly in your code. Next time please post the exact error, it will probably get you a quicker and more accurate answer. The following lines create errors because VBA thinks you are trying to create a new variable type called UserForm1. Since you only provided code excerpts the fix below will correct your compile errors ONLY.

    I do not see how the code will run without correcting the errors below. The errors occur with or without 'Option Explicit' which is HIGHLY RECOMMENDED.

    To fix the compiler errors:
    Delete or comment out the following line
    Please Login or Register  to view this content.
    Change the text in red on the following line to the text in blue in the line below.
    Please Login or Register  to view this content.
    Lewis
    Last edited by LJMetzger; 11-09-2019 at 01:30 PM.

  3. #3
    Registered User
    Join Date
    07-18-2017
    Location
    evansville
    MS-Off Ver
    2016
    Posts
    5

    Re: Form resizer works on my work computer, but not at my home computer.

    Hi Lewis, thank you for the help! I wasn’t sure if I could post the entire excel UserForm or not. I don’t have any secure information in it, it is just used to submit data to me to process.

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Form resizer works on my work computer, but not at my home computer.

    To upload a sample workbook, Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Remember to desensitize the data.

    A sample workbook is a lot better than just code or a picture. It will usually get you a quicker and more accurate reply.

    Lewis

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Form resizer works on my work computer, but not at my home computer.

    Do you have 32 or 64bit Office at home? One of your 64 bit declarations is incorrect; it should be:

    Please Login or Register  to view this content.
    Rory

  6. #6
    Registered User
    Join Date
    07-18-2017
    Location
    evansville
    MS-Off Ver
    2016
    Posts
    5

    Re: Form resizer works on my work computer, but not at my home computer.

    Hi All,
    I made the suggested changes, but still can't resolve the same error.
    I attached a copy of my Userform.
    Thank You,
    Steve
    Attached Files Attached Files

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Form resizer works on my work computer, but not at my home computer.

    I can't see much wrong there, but try changing the declaration block to this:

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    07-18-2017
    Location
    evansville
    MS-Off Ver
    2016
    Posts
    5

    Re: Form resizer works on my work computer, but not at my home computer.

    Hi All,
    I forgot to remove edit password. rorya, your suggestion seems to have solved the error. I have 64bit at home and 32bit at work computer.
    Attached Files Attached Files

+ 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. Identical VBA Code works on computer A, throws error on computer B???
    By PWM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2018, 08:15 AM
  2. Replies: 3
    Last Post: 05-18-2018, 08:20 AM
  3. [SOLVED] Add computer to home network
    By bigband1 in forum The Water Cooler
    Replies: 6
    Last Post: 11-27-2017, 02:42 AM
  4. [SOLVED] VLOOKUP returns #N/A on work compute but return correct answer on home computer
    By Tyso in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-13-2016, 08:40 AM
  5. Replies: 8
    Last Post: 12-15-2014, 04:36 PM
  6. VLookup works in my computer, but not in another user computer.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2013, 04:41 PM
  7. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 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