Anything like STRUCT in VBA?
On Jun 2, 7:48*am, NateBuckley
wrote:
Hello I need to return about 4 pieces of data, two of type string and two of
type integer. I could create a Class and do it that way, but I'm only going
to need to send this data back once, and within this one module, so I thought
it may be better coding practice to just use something like a STRUCT?
Is there perhaps a way to create a STRUCT data type and return that?
Thanks for any help.
Nate
Private Type yourType
string1 As String
string2 As String
int1 As Integer
int2 As Integer
End Type
Sub example()
Dim yType As yourType
yType.string1 = "hello"
yType.string2 = "you"
yType.int1 = 12
yType.int2 = 34
End Sub
|