Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My problem is that I am trying to create a reference to an object and pass
that objects address in a subroutine called examineData, which should produce a msgbox detailing the information placed in the object "person". I believe I am passing a reference address to my object I created in subroutine testReference, to the subroutine examineData. But this module wont compile. From microsofts help files: "You can combine declaring an object variable with assigning an object to it by using the New keyword with the Set statement. For example:Set MyObject = New Object ' Create and Assign" '------------------------------------------------------------------------- Type myData age As Integer wageEarner As Boolean End Type Sub testReference() Dim person As myData ' here I believe I created the pointer to my object person Set personPtr = New person ' here I am giving my object some data person.age = 10 person.wageEarner = True 'here I pass my reference to my object person in the following subroutine examineData (personPtr) End Sub Sub examineData(aPerson As myData) If (aPerson.wageEarner = True) Then MsgBox "The age is " + Trim(Str(aPerson.age)) + Chr(13) + _ "They are wage earner" Else MsgBox "The age is " + Trim(Str(aPerson.age)) + Chr(13) + _ "They are wage earner" End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA - passing Variables to subroutines | Excel Discussion (Misc queries) | |||
Passing Variables | Excel Discussion (Misc queries) | |||
VBA passing variables through a function | Excel Discussion (Misc queries) | |||
Passing variables between a form and macro | New Users to Excel | |||
passing variables from excel to word | Excel Programming |