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

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" wrote in message
...
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