+ Reply to Thread
Results 1 to 5 of 5

UserForm "run time Error 424 Object Required"

  1. 07-08-2014, 01:47 AM #1
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    UserForm "run time Error 424 Object Required"

    Hi Everyone

    I have created this Basic form but for some reasons when I try to call the form I get error message "run time Error 424 Object Required"

    Can you help please ?

    Thank you

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-08-2014, 02:13 AM #2
    patel45
    patel45 is offline
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: UserForm "run time Error 424 Object Required" 

    Please Login or Register  to view this content.
    no listbox in your userform
    If solved remember to mark Thread as solved
    Reply With QuoteRegister To Reply
  3. 07-08-2014, 02:27 AM #3
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: UserForm "run time Error 424 Object Required"

    Sorry I m a VBA Beginner, but I think I vaguely know what you mean, I guess I have to create a list box with data validation on the worksheet.

    Do you mind giving me step by step how to add the list box to the form ?

    Thanks
    Reply With QuoteRegister To Reply
  4. 07-08-2014, 04:54 AM #4
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: UserForm "run time Error 424 Object Required"

    No - you need a listbox on the userform since your code is trying to add the data from A2:A5 to a listbox that doesn't exist.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
  5. 07-10-2014, 07:47 AM #5
    bimo
    bimo is offline
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: UserForm "run time Error 424 Object Required"

    Thank you guys.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro generates the following error: "run-time error 424 object required"
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2014, 06:31 PM
  2. Run-time error "424": Object required
    By TGM™ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2012, 05:57 AM
  3. [SOLVED] "Run-time error '424': Object required" error
    By jaff84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2012, 10:43 AM
  4. [SOLVED] Excel 2007 : Help to Solve Run-time Error 424 "Object Required"
    By D.S.Rama Rao in forum Excel General
    Replies: 6
    Last Post: 03-05-2012, 03:24 PM
  5. "Microsoft Visual Basic runtime error '424' object required".
    By SharonG. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2006, 08:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1