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
and I declared as Public - but cant seem to pick it up with the UserformInitilise code which is
Any pointers appreciated
Bookmarks