View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
NateBuckley NateBuckley is offline
external usenet poster
 
Posts: 146
Default Anything like STRUCT in VBA?

Thanks for your reply anyways!

Cheers

"JW" wrote:

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.