Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello and goodmorning, I don't know if this is possible but I would like to
pass an object to an event. I want to do something like this: sub main() dim somearray(50) as string .... other code call commandbutton_Click(byval somearray()) .... other code end sub private sub commandbutton_Click(somearray() as string) .... code goes here end sub my problem is that when I do this it says that there is a duplicate private sub commandbutton_Click(somearray() procedure and wrong number of arguments. I am wondering what I can do. Maybe a class? I am not sure what I can do. Any help would be greatly appreciated. Paul PS Any additional information you may need please let me know and I will provide it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing Arguments in Excell | Excel Worksheet Functions | |||
Passing arguments to VB Function | Excel Programming | |||
Use of public variables vs. passing arguments | Excel Programming | |||
Passing Arguments | Excel Programming | |||
Passing arguments to a sub routine... | Excel Programming |