Database Reference
In-Depth Information
Figure 10.9
ThisWorkbook.
Figure 10.10
Adding the change event.
Adding the event method template code is as simple as clicking the left dropdown
above the code and selecting cboSegment. This will immediately add the _Change event
(Figure 10.10).
Private Sub cboSegment_Change()
'we pass this empty collection over to the
'lookUpDimMemberList method to be populated
'with a list of Channel members that are valid
'with the currently selected Segment.
Dim lookupMatches As New Collection
Dim selectDimensionName As String
Dim lookupDimensionName As String
Dim selectedMember As String
selectedMember = cboSegment.Text
selectDimensionName = "Segment"
lookupDimensionName = "Channel"
cboChannel.Clear
'use our previously coded method to get lookup the member(s)
that
'are valid with the currently selected Segment member.
lookupDimMemberList selectedMember, selectDimensionName,
lookupDimensionName, lookupMatches
Dim foundMember As Variant
