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

Hi,

See help on the TYPE for creating user-defined data type containing one or
more elements

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NateBuckley" <(E-Mail Removed)> wrote in message
news:12B40C12-0009-4F58-8251-(E-Mail Removed)...
> 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
>

Thanks matey thats precisly what I was looking for.

Cheers!

"Andy Pope" wrote:

> Hi,
>
> See help on the TYPE for creating user-defined data type containing one or
> more elements
>
> Cheers
> Andy
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "NateBuckley" <(E-Mail Removed)> wrote in message
> news:12B40C12-0009-4F58-8251-(E-Mail Removed)...
> > 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
> >
>

On Jun 2, 7:48*am, NateBuckley <NateBuck...@discussions.microsoft.com>
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

On Jun 2, 8:18*am, JW <JWRIGH...@triad.rr.com> wrote:
> On Jun 2, 7:48*am, NateBuckley <NateBuck...@discussions.microsoft.com>
> 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.

Thanks for your reply anyways!

Cheers

"JW" wrote:

> On Jun 2, 8:18 am, JW <JWRIGH...@triad.rr.com> wrote:
> > On Jun 2, 7:48 am, NateBuckley <NateBuck...@discussions.microsoft.com>
> > 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.
>