View Single Post
  #5   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, 8:18*am, JW wrote:
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


Welp, looks like I'm a little late. lol. Glad you got what you
needed.