Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a variable declared in VBA | Excel Worksheet Functions | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
Passing Public Module Vairable to a Worksheet Event | Excel Programming | |||
declaring a public array | Excel Programming | |||
Public Array | Excel Programming |