PC Review


Reply
Thread Tools Rate Thread

?? Create a Public SUB with an array as parameter. ??

 
 
=?Utf-8?B?QmFyYg==?=
Guest
Posts: n/a
 
      23rd Jul 2007

I created a class

public sub FindInIt(myArray() as double)
...

End sub

When I’m creating an object to call that sub ,
Obj.FindInIt(ThisismyArray) then

I receive an error message that says …. Compile error expected =

like if it was a function. My question is can I pass an array by reference?

Thanks.

 
Reply With Quote
 
 
 
 
NickHK
Guest
Posts: n/a
 
      24th Jul 2007
Read the VBA help on the Call statement.

NickHK

"Barb" <(E-Mail Removed)> wrote in message
news:272F5E0E-5D55-4DD7-A789-(E-Mail Removed)...
>
> I created a class
>
> public sub FindInIt(myArray() as double)
> ..
> .
> End sub
>
> When I'm creating an object to call that sub ,
> Obj.FindInIt(ThisismyArray) then
>
> I receive an error message that says .. Compile error expected =
>
> like if it was a function. My question is can I pass an array by

reference?
>
> Thanks.
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
array as out parameter Hendri Adriaens Microsoft C# .NET 5 15th May 2007 08:01 PM
Parameter Query & Public Variables? =?Utf-8?B?RS5RLg==?= Microsoft Access Getting Started 1 9th Apr 2007 11:58 AM
public array Circe Microsoft Excel Programming 6 17th May 2005 11:45 PM
ReDim Object array as parameter of Variant array Peter T Microsoft Excel Programming 4 10th May 2005 02:11 PM
Array as parameter from VC++ DLL to VB.NET Sarvjeet Saini Microsoft ASP .NET 0 28th Aug 2003 09:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:33 AM.