Instatiating a class with defualt params

MikeroSoft · #1 (**permalink**) 06-20-06, 10:46

I created a class trade and added all my public and private items

i would like the constructor to take 5 params, like :

dim t as new trade(Parm1,Parm2,Parm3)

is this possible with VBA?

spikey_richie · #2 (**permalink**) 06-20-06, 11:17

Yes, in your class module do something like this

Code:

Public Sub Trade(param1 as string, param2 as string, param3 as string) As String
' we use sub instead of function as we're not looking for a return value
end sub

mkggoh · #3 (**permalink**) 06-20-06, 21:16

Quote:

Originally Posted by spikey_richie

Yes, in your class module do something like this

Code:

Public Sub Trade(param1 as string, param2 as string, param3 as string) As String
' we use sub instead of function as we're not looking for a return value
end sub

but you are looking for a return value which is String. I bet this will cause an error

spikey_richie · #4 (**permalink**) 06-20-06, 21:23

Why not just say "remove the As String from the end as it'll cause an error"?

MikeroSoft · #5 (**permalink**) 06-21-06, 09:49

actualy i am returning an object representing a stock exchange trade, so i will be seting a ref to the obj then using some of its functions & Properties

dim msft as new trade(Shares,price, commishion, purchdate)

msgbox "You now own " & msft.Shares & " Shares of Microsoft"

Internet Services

Web Development

Digital Marketing

Consumer Tech