Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
I am trying to pass an array to a subroutine. I always get an error.
in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) .. .. .. Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
Changing List() to List will work, however, it would be better to use
another variable name; maybe vList. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "DRA" wrote in message I am trying to pass an array to a subroutine. I always get an error. in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
Sub MyListBox(Cptn As String, ByRef List, Item)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DRA" wrote in message ... I am trying to pass an array to a subroutine. I always get an error. in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) . . . Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
Try removing the () after List, ie:
Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) A variant can hold an array by itself. You do not need an array of Variants. Regards, Steve DRA wrote: I am trying to pass an array to a subroutine. I always get an error. in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) . . . Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
Thanks to all of!
DRA " wrote: Try removing the () after List, ie: Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) A variant can hold an array by itself. You do not need an array of Variants. Regards, Steve DRA wrote: I am trying to pass an array to a subroutine. I always get an error. in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) . . . Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
using array as argument in VBA sub
Or do it this way in Excel 2000 or later:
Sub AAA() Dim MMBkList() As Variant MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash ") Call MyListBox("Add to which Column?", MMBkList, col) End Sub Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) End Sub -- Regards, Tom Ogilvy "DRA" wrote in message ... Thanks to all of! DRA " wrote: Try removing the () after List, ie: Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) A variant can hold an array by itself. You do not need an array of Variants. Regards, Steve DRA wrote: I am trying to pass an array to a subroutine. I always get an error. in calling code: MMBkList = Array("Add to Not Budgeted", "Add to Charity", "Add to Cash") Call mylistbox("Add to which Column?", MMBkList, col) . . . Sub MyListBox(Cptn As String, ByRef List() As Variant, Item) Help? Thanks, DRA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a conditional argument to check all cells in a array? | Excel Worksheet Functions | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
Function (array argument, range argument, string argument) vba | Excel Programming | |||
Need help passing an array as an argument | Excel Programming | |||
Array as Argument in User-Defined Functions | Excel Programming |