Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
At a certain point in my code module, I need my user to determine which of the worksheets in the workbook need further processing. In order to accomplish this I made a UserForm with a ListBox. It lists all the worksheets in the workbook. The user pics the worksheets that need further processing, which I store that in a Collection. That part seems works fine. My problem is that I can't seem to pass the collection back to the module. I can pass a variant OK, but I can't seem to pass a collection. What's a good way to approach this? Many Thanks. -- Programmer on Budget |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call a sub in a modeless userform from a code module? | Excel Programming | |||
Pass worksheet object name to a class module | Excel Programming | |||
Pass variable from module to userform and back | Excel Programming | |||
Code in userform/worksheet vs. in Module | Excel Programming | |||
How to pass values from a userform to a standard module? | Excel Programming |