VB and VBA Users Source Code: Copy data in a user defined type/structure using LSET
[
Home
|
Contents
|
Search
|
Reply
| Previous | Next ]
VB/VBA Source Code
Copy data in a user defined type/structure using LSET
By:
Andrew Baker
Email (spam proof):
Email the originator of this post
Date:
Monday, February 19, 2001
Hits:
590
Category:
Visual Basic General
Article:
Option Explicit Private Type tTestStruct sName As String sAddress As String lAge As Long End Type Sub CopyTypeDemo() Dim tMyDetails As tTestStruct, tCopyMyDetails As tTestStruct 'Set type values tMyDetails.sAddress = "Somewhere over the rainbow" tMyDetails.sName = "Wicked Witch of the East" tMyDetails.lAge = 29 'Copy data in type LSet tCopyMyDetails = tMyDetails Debug.Print tCopyMyDetails.sName Debug.Print tCopyMyDetails.sAddress Debug.Print tCopyMyDetails.lAge End Sub
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
