View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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