I wonder if anyone could let me know what are the main advantages / disadvantages of creating a UDT, for example:
Private Type myPerson
strName As String
intAge As Integer
lngHeight As Long
lngWeight As Long
End Type
over declaring these variables separately as below:
Dim strName As String
Dim intAge As Integer
Dim lngHeight As Long
Dim lngWeight As Long
What would be the difference in memory usage?
Many thanks in advance
Private Type myPerson
strName As String
intAge As Integer
lngHeight As Long
lngWeight As Long
End Type
over declaring these variables separately as below:
Dim strName As String
Dim intAge As Integer
Dim lngHeight As Long
Dim lngWeight As Long
What would be the difference in memory usage?
Many thanks in advance