Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anything like STRUCT in VBA?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anything like STRUCT in VBA?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
class/struct functionality in VBA? | Excel Programming | |||
Emulate C/C++ struct in VBA? | Excel Programming |