+ Reply to Thread
Results 1 to 4 of 4

Replace a source list from a range with a source list from an array

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Replace a source list from a range with a source list from an array

    I have a userform that lists workbooks in a directory for printing purposes, the option buttons assigned to the the workbook a loaded from a list created on WorkbookOpen

    Instead of adding one more list to a complex workbook I want to replace the list with an array created at WOrkBook Open

    This part I have and I can check and see the array in the intermediate window

    I want to pass that list to the Userform Initialise sub but am struggling with the syntax of addressing the array

    Maybe the method used to create the option buttons needs changing

    The array is created
    Please Login or Register  to view this content.
    and I declared as Public - but cant seem to pick it up with the UserformInitilise code which is

    Please Login or Register  to view this content.
    Any pointers appreciated
    Attached Files Attached Files
    Last edited by nigelog; 06-22-2018 at 10:47 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,884

    Re: Replace a source list from a range with a source list from an array

    Remove the line in red
    Please Login or Register  to view this content.
    Again remove both lines in red & make the change in blue
    Please Login or Register  to view this content.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Replace a source list from a range with a source list from an array

    Thankyou fluff13, much appreciated. I was skirting around it for hours without quite getting it

    works and save a worksheet or list reference, needed as the list will always be changing

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,884

    Re: Replace a source list from a range with a source list from an array

    Glad to help & thanks for the feedback

+ 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. Drop Down List Auto Grow (from non source range)
    By OtisAir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2018, 10:46 AM
  2. Using an Array Formula as source for Data Validation List
    By Tlhompho in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2017, 12:27 PM
  3. Replies: 0
    Last Post: 10-06-2016, 11:36 AM
  4. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  6. Replies: 5
    Last Post: 08-13-2011, 11:27 AM
  7. FORMULA at Source range (in Data->validation->List) gives wrong re
    By Eddy Stan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2006, 03:25 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