+ Reply to Thread
Results 1 to 5 of 5

Compile Error - Object Required when opening Userform on another PC

  1. #1
    Registered User
    Join Date
    03-02-2015
    Location
    Berkshire
    MS-Off Ver
    2013
    Posts
    21

    Compile Error - Object Required when opening Userform on another PC

    Hi

    I could really do with some help! I've created a userform in Excel 2013 and it was running beautifully. I sent it to another colleague for testing on their PC on Excel 2010and I am having lots of problems

    When I try to run the following bit of code I keep getting the Compile error - object required and it highlights patientrec. I'm new to VBA and really can't work out why this works on my PC but not my colleagues.

    I'd be so grateful for any help - thank you!!

    Please Login or Register  to view this content.
    Last edited by Scoobymoo; 05-13-2015 at 05:49 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    43,720

    Re: Compile Error - Object Required when opening Userform on another PC

    Suggest you post a sample workbook. Most likely its a MISSING reference.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-02-2015
    Location
    Berkshire
    MS-Off Ver
    2013
    Posts
    21

    Re: Compile Error - Object Required when opening Userform on another PC

    Thank you TMS. The problem with my workbook is it's pretty large and there is a lot of client sensitive information on it including the field names so I'm not too sure how to post a sample without compromising this?

    I have meanwhile googled the missing reference and discovered some instructions on changing this. When I went to tools > references, there was a MISSING reference: Microsoft windows common controls - 2 6.0 (SPS). I have unchecked this as suggested in the instructions and the form appears to continue to run. I am still really worried though as I don't really understand what I have done by unchecking this box and if it is a) likely to create any problems now I have unticked the box/ stop part of the form from working or b) resolve the problem for all users if I save it like this and send the new version out?

    Essentially, I have created the form/ questionnaire for a client who will be emailing it out to several users so they can input records and then return the data to the client. I have spent hours on it and I really thought I was there but I am now very nervous about it being distributed.

    Any advice would be really appreciated -totally out of my depth now

    Thank you!

  4. #4
    Registered User
    Join Date
    03-02-2015
    Location
    Berkshire
    MS-Off Ver
    2013
    Posts
    21

    Re: Compile Error - Object Required when opening Userform on another PC

    I am changing this to solved as having investigated the missing reference, I have a new question for which I've opened up a new thread. Hope that's the correct way of doing things - thank you!

  5. #5
    Registered User
    Join Date
    03-02-2015
    Location
    Berkshire
    MS-Off Ver
    2013
    Posts
    21

    Re: Compile Error - Object Required when opening Userform on another PC

    I created a new thread for this because I thought I had solved the initial problem and my question now differs from the original thread question. Apparently that is not the correct thing to do so I am using this one again. Apologies, new to this

+ 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. [SOLVED] List of items in a userform listbox, object required error in code
    By jayherring86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2015, 09:10 AM
  2. [SOLVED] 424 Object required error when calling a UserForm from another
    By rybussell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2013, 01:16 PM
  3. Compile error: Object required
    By Hinnerk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-23-2012, 04:38 PM
  4. Compile error : object required in userform
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2010, 04:08 AM
  5. [SOLVED] VBA Help needed -- compile error: object required
    By alexandraVBAgirl in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-17-2006, 09:00 AM

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