Results 1 to 6 of 6

[SOLVED] Arrays: Run-time error '424': Object required

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2015
    Location
    NoWhere, USA
    MS-Off Ver
    2013
    Posts
    4

    [SOLVED] Arrays: Run-time error '424': Object required

    I have created a user form that has a row of ComboBoxes I need filled with a bunch of sites. I had this set up to list in each ComboBox, but the code was getting way too long so I decided to try and declare the array and list it in the ComboBoxes that way. However, I am getting the above error and cannot figure out if I missed a step or have something written wrong. Any help would be greatly appreciated.

    Private Sub UserForm_Initialize()
    'Declare arrays to use in ComBoxes
    Dim SitesArray As Variant
    SitesArray = Array("Alexandria (L: Drive):", "Boonville (H: Drive)", _
    "Boonville (P: Drive)", "Brampton (I: Drive)", "Burnaby (I: Drive), _
    "Hilroy (L: Drive)", "Kemper/Lincolnshire (G: Drive)", "Kemper/Lincolnshire (I: Drive)", _
    "Kemper/Lincolnshire (K: Drive)", "Kemper(S: Drive)", "Kettering (L: Drive)", _
    "Ogdensburg (I: Drive)", "Ontario (I: Drive)", "Pleasant Prairie (G: Drive)", _
    "San Mateo/RWS (I: Drive)", "Sidney (L: Drive)", "Sidney AFSP1 (R: Drive)", _
    "Sidney MGPP1 (M: Drive)", "MCOP local (T: Drive)", "")
    
    'Dim ReadWriteArray As Variant
    'ReadWriteArray = Array("Read", "Write", "")
    
    ComboBox3.List = Array("Engineering Laptop - For limited Users", "Light Wieght Laptop", "Standard Laptop", "Stanard Destop", "Mac Pro Laptop - For certain areas only", _
    "iMac - For certain areas only", "Mac Pro Desktop - For certain areas only", "")
    'Set ComboBoxes to show array
    SiteComboBox1.List = SitesArray
    
    End Sub
    Last edited by Billroz; 03-02-2016 at 08:20 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run-time error '424' - Object Required HELP
    By EC37 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2015, 11:38 AM
  2. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  3. [SOLVED] Run-Time Error Object Required
    By Trevasaurus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2013, 01:20 PM
  4. [SOLVED] Run time error 424, object required.
    By ndtsteve in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2012, 05:16 AM
  5. Run-time error '424' object required
    By PaPaDiZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2011, 05:31 AM
  6. Getting Run Time Error 424 object required
    By arvin in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-11-2010, 01:36 PM
  7. Run-time error '424': Object required
    By ez_cali in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-21-2005, 03:52 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