+ Reply to Thread
Results 1 to 7 of 7

Trying to put everything together - runtime error 424 object required

  1. #1
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Trying to put everything together - runtime error 424 object required

    Everyone has been super helpful and I really appreciate everything.
    I've tried to put everything I've learned together to create a Meal Planner and Shopping list. My first version worked well but I've been trying to add a couple of features based on some feedback.

    Now, I've tried to include what I've learned the past few days/weeks but when I try and launch my userform I'm getting a runtime error 424 object required popup.
    I've been through the code, cut some out, added some in, tested this, tried that but I can't seem to shift the error.

    Would anyone be able to help? I don't know what's going wrong in there.

  2. #2
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Re: Trying to put everything together - runtime error 424 object required

    Found a few missing End If statements and added those but I'm still getting the error.

  3. #3
    Forum Contributor
    Join Date
    08-09-2012
    Location
    British Columbia
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: Trying to put everything together - runtime error 424 object required

    In the ShrinkDictionary module you are trying to load the dictionary from the variable IngredientList which has not been set to anything.

  4. #4
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Re: Trying to put everything together - runtime error 424 object required

    Quote Originally Posted by NoSparks View Post
    In the ShrinkDictionary module you are trying to load the dictionary from the variable IngredientList which has not been set to anything.
    Okay, I had just narrowed it down to that module
    Now, I thought i was setting it to sheet IngredientList row A but am I wrong? I know there is nothing in the list yet, but that's a list which will be populated in time.

  5. #5
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Re: Trying to put everything together - runtime error 424 object required

    I fixed that error now and can access the userform

    Please Login or Register  to view this content.
    Only now my ComboBox list doesn't see to work. It doesn't doesn't seem to give any list.

  6. #6
    Forum Contributor
    Join Date
    10-30-2006
    MS-Off Ver
    O365
    Posts
    311

    Re: Trying to put everything together - runtime error 424 object required

    I got it

    Please Login or Register  to view this content.

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Trying to put everything together - runtime error 424 object required

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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
    By CBalazic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2015, 01:02 PM
  2. Runtime Error - Object Required
    By darkblueblood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2014, 07:21 AM
  3. [SOLVED] Runtime error 424 Object Required - HELP ME
    By joh46k in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-09-2013, 03:26 AM
  4. Runtime error 424 Object Required - HELP ME
    By joh46k in forum Excel General
    Replies: 1
    Last Post: 05-09-2013, 01:09 AM
  5. [SOLVED] Runtime Error '424': Object Required.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2012, 02:37 PM
  6. Runtime Error '424' - Object Required
    By ffffloyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2011, 09:52 PM
  7. Runtime Error 424 - Object Required
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2009, 04:04 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