Results 1 to 2 of 2
  1. #1
    RMittelman is offline Advanced
    Windows 10 Access 2016
    Join Date
    Dec 2010
    Simi Valley, CA

    List / Array / Collection Acting like Enumeration

    You know how you can create an enumeration like

    Enum MyEnum
    End Enum
    and use it in code like
    Sub MyMethod(myChoice As MyEnum)
    End Sub
    Then when you call the method from the outside, right after you type the open parenthesis, it drops down the list of choices.

    Is there any way to do that without the enumeration, but based on an array or collection of known values?

    I want to use this in a class, so it could be in a method or a Property Let statement.


  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Not sure; haven't done much with classes.
    Seems not with Classes as per this link from Chip Pearson's site

Please reply to this thread with any new information or opinions.

Similar Threads

  1. 2-Dim array as list to a ListBox
    By Joakim N in forum Forms
    Replies: 4
    Last Post: 11-10-2016, 10:15 AM
  2. How to populate list box from an array?
    By AAAndy in forum Forms
    Replies: 5
    Last Post: 08-19-2016, 08:23 AM
  3. Replies: 3
    Last Post: 11-16-2012, 10:15 AM
  4. list files recursively and store results in array
    By maxbre in forum Programming
    Replies: 2
    Last Post: 11-10-2011, 01:49 AM
  5. Replies: 2
    Last Post: 09-29-2011, 12:50 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums