+ Reply to Thread
Results 1 to 4 of 4

Runtime error 424 Object required

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    880

    Runtime error 424 Object required

    Hi All

    When I open the workbook then Frmmain displays on the screen. I type in all the information and when I press SAVE button then above error message appears in the following line:
    Please Login or Register  to view this content.
    Is it because the FrmReturn is not shown? I don't want FrmReturn to appear upon Frmmain as I want FrmReturn to be in the back so that the data from Frmmain can be tranferred to FrmReturn and when required then only we can see FRMReturn on the screen.

    Any ideas how to do that?

    Many Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,283

    Re: Runtime error 424 Object required

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    880

    Re: Runtime error 424 Object required

    please see attached the spreadsheet. This is designed to be used by multiple users so that each user will be using its own copy as On the workbook_open event two functions are called which helps in opening a copy of it for each user. Now initially FRmmain gets displayed and when the user types in all the information and press save then an error appears at fRmReturn line as below:
    Please Login or Register  to view this content.
    but from this FRmain I want to display some values in FRmreturn but FRmreturn should be displayed under frmmain or can be hidden. Dont know how to do it.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Runtime error 424 Object required

    The error is actually occuring in the Initialize event of FrmReturn and the cause of problem is that there is no ComboBox2 on that form.
    If posting code please use code tags, see here.

+ 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. Runtime error 424 Object Required - HELP ME
    By joh46k in forum Excel General
    Replies: 1
    Last Post: 05-09-2013, 01:09 AM
  2. [SOLVED] Runtime Error: 424 Object Required
    By Sleepyshy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2013, 05:53 PM
  3. [SOLVED] Runtime Error '424' Object Required
    By kboy1289 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-09-2012, 04:29 PM
  4. Runtime Error '424' - Object Required
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2011, 09:52 PM
  5. Runtime error 424, Object required
    By Ajain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2010, 03:50 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