+ Reply to Thread
Results 1 to 5 of 5

VBA Auto - Complete missing properties

  1. #1
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    VBA Auto - Complete missing properties

    In Excel VBA, I've added a reference to mscorlib.dll so that I can make use of the ArrayList class within it.

    For some reason the methods of the class, such as .Add are not visible in the object browser (see Image).

    With Dim myArrayList As mscorlib.ArrayList, Intellisense also doesn't give me any prompts

    What is the reason?

    Arraylist.jpg

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA Auto - Complete missing properties

    You need to set the reference to

    C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.tlb

  3. #3
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: VBA Auto - Complete missing properties

    Hi jindon

    Still not.

    Is there a problem with my computer?

    Snap13.jpg
    Last edited by chief_abound; 11-19-2018 at 12:55 AM.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: VBA Auto - Complete missing properties

    Ahh, I didn't see your picture.

    As it uses only the part of the dll in vba, so I don't think it appears.

  5. #5
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: VBA Auto - Complete missing properties

    Thank you so much!

+ 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. Formula to check if set is complete & missing item.
    By seercoven in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2016, 04:40 AM
  2. Replies: 2
    Last Post: 12-29-2015, 03:51 PM
  3. Properties of Modules in VB editor missing (Office 365 - Mac - Yosemite)
    By crehan57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2015, 09:28 AM
  4. Formula with Macro not pasted complete, ' missing
    By Dubrock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 07:57 AM
  5. Consolidating missing data across multiple rows into one complete row
    By pilboroughv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-19-2014, 07:05 AM
  6. Complete Missing Row Data based on Row above
    By SamLN in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-22-2014, 04:54 AM
  7. Macros/Finding missing and complete addresses
    By tutv088 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 12:27 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