View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Budget Programmer Budget Programmer is offline
external usenet poster
 
Posts: 46
Default Pass Object from UserForm to Code Module

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