View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amzee Amzee is offline
external usenet poster
 
Posts: 2
Default How to reference a public array (declared in module) from a proced

I can reference a listbox in a Worksheet using the following

Public Sub Procedure1(worksheetName As String, listBoxName As String)
Dim listSize As Integer
listSize = Worksheets(worksheetName).OLEObjects(listBoxName). Object.ListCount
......
end sub

How do I do the same for a public array (declared in a module) with the
following procedure??

Public Sub setSelections(arrayName as String)
????.....
end sub

Thanks!