Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi everybody
i have copied the the code below from helpFile from "Implement statement" and have pasted the code accordingly . while running the coed i get error message as "Method or Data Member not defined when i click any of the commandButton please explain The following code for the shared declarations is in a class called PersonalData: Public Name As String Public Address As String The code supporting the customer data is in a class module called Customer: Implements PersonalData Private Property Get PersonalData_Address() As String PersonalData_Address = "CustomerAddress" End Property Private Property Let PersonalData_Address(ByVal RHS As String) ' End Property Private Property Let PersonalData_Name(ByVal RHS As String) ' End Property Private Property Get PersonalData_Name() As String PersonalData_Name = "CustomerName" End Property The code supporting the supplier data is in a class module called Supplier: Implements PersonalData Private Property Get PersonalData_Address() As String PersonalData_Address = "SupplierAddress" End Property Private Property Let PersonalData_Address(ByVal RHS As String) ' End Property Private Property Let PersonalData_Name(ByVal RHS As String) ' End Property Private Property Get PersonalData_Name() As String PersonalData_Name = "SupplierName" End Property The following code supports the Selector form: Private cust As New Customer Private sup As New Supplier Private Sub Command1_Click() Dim frm2 As New Form2 Set frm2.PD = cust frm2.Show 1 End Sub Private Sub Command2_Click() Dim frm2 As New Form2 Set frm2.PD = sup frm2.Show 1 End Sub The following code supports the Data Entry form: Private m_pd As PersonalData Private Sub Form_Load() With m_pd Text1 = .Name Text2 = .Address End With End Sub Public Property Set PD(Data As PersonalData) Set m_pd = Data End Property -- hemu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |