Results 1 to 5 of 5

Compile Error - Object Required when opening Userform on another PC

Threaded View

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

    Private Sub CBUpdateRecord_Click()
    
    Dim answer As Integer
    answer = MsgBox("Are you sure you want to update the existing patient record?", vbYesNo + vbQuestion, "Empty Sheet")
    If answer = vbYes Then
        
    With Sheets("Data")
    
    Set patientrec = .Range("b:b").Find(What:=TextPatientID.Value, LookIn:=xlValues)
    
    End With
    Last edited by Scoobymoo; 05-13-2015 at 05:49 AM.

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