+ Reply to Thread
Results 1 to 18 of 18

Runtime Error # 424 - Object Required

  1. #1
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Exclamation Runtime Error # 424 - Object Required

    Hey

    I try to run attached excel file which store customer data (Address).
    But I am getting "Runtime Error # 424 - Object Required"
    I Am really confused about it.

    Can u please Help me?

    Regards
    Charles
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    hi ebin
    Runtime Error # 424 - Object Required
    indicated the userform had an error on opening
    Attached Files Attached Files
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    You have disabled "Aip.Txt...

    I cannot enter or save the data.

    When I open the form it give error mesg " Invalid Row..." I cannot go further.

    Please help me.

    Regards
    Charles

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    ebin
    close but no banana
    Attached Files Attached Files

  5. #5
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    Now I am geting Error # 13

    Type Mismatch..

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    which line as it the example works we for me

  7. #7
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    Sir,

    It shows me the error:

    Runtime Error # 13
    Type mismatch...

    This error shows in the line no. 126 Column 1

    I attach the corrected workbook.

    can u help me?

    Regds
    charles
    Attached Files Attached Files

  8. #8
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    can you copy the line?

  9. #9
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    There is bold line the below code
    this line shoe error Runtime Error 13, Type mismatch

    is CustomerID.Text = FormatNumber(Cells(r, 1), 0)


    Please Login or Register  to view this content.

  10. #10
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    strange it runs ok for me
    change from
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    text to number format?

  11. #11
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    Now i am getting error the same

    Runtime error 13 - type mismatch

    @ line DateAdded.Text = FormatDateTime(Cells(r, 6), vbShortDate)

    Please Login or Register  to view this content.

  12. #12
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    hi ebin
    hmmm..
    for the moment try
    a/. adding some values to the date column
    or
    b/.
    change the code to
    Please Login or Register  to view this content.
    this will disable the line for the moment

  13. #13
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    my master

    thank you so much. you are so greatful.
    i have learned from so much.

    the format of date in my sheet is not correct. i think.

    otherthan that it is working.

    thank you

    regards
    charles

  14. #14
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    no master my friend
    just an average punter - thanks for posting you question and glad you are learning
    dont forget to change your thread prefix to solved

  15. #15
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Runtime Error # 424 - Object Required

    Sir,

    I need to enter the address of the customer in that form.

    Can I? When i try to enter the contact i cannot.

    Please

    Regards
    Charles

  16. #16
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    master here you go
    Attached Files Attached Files

  17. #17
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Runtime Error # 424 - Object Required

    ebin
    dont forget to change the thread prefix to solved as it will help others search for a silimar answer

  18. #18
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Runtime Error # 424 - Object Required

    Depending on the existing situation

    Please Login or Register  to view this content.
    But do not use a loop.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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