T
TVComputer
I am using a combo box to allow the user multiple selections on a
list. Once choices are selected I want to show text boxes that
correlate only to those selection and make the rest hidden.
Here's what I have so far:
Private Sub ComboBoxA_LostFocus()
If ComboBoxA.Selected(ChoiceA) = True Then
TextBoxA.Visible = True
Else: TextBoxA.Visible = False
End If
If ComboBoxA.Selected(ChoiceB) = True Then
TextBoxB.Visible = True
Else: TextBoxB.Visible = False
End If
If ComboBoxA.Selected(ChoiceC) = True Then
TextBoxC.Visible = True
Else: TextBoxC.Visible = False
End If
End Sub
The problem I am having is everything is reliant on ChoiceA. If
ChoiceA is selected then all are visible, if ChoiceA is deselected,
all are hidden. What am I missing?
list. Once choices are selected I want to show text boxes that
correlate only to those selection and make the rest hidden.
Here's what I have so far:
Private Sub ComboBoxA_LostFocus()
If ComboBoxA.Selected(ChoiceA) = True Then
TextBoxA.Visible = True
Else: TextBoxA.Visible = False
End If
If ComboBoxA.Selected(ChoiceB) = True Then
TextBoxB.Visible = True
Else: TextBoxB.Visible = False
End If
If ComboBoxA.Selected(ChoiceC) = True Then
TextBoxC.Visible = True
Else: TextBoxC.Visible = False
End If
End Sub
The problem I am having is everything is reliant on ChoiceA. If
ChoiceA is selected then all are visible, if ChoiceA is deselected,
all are hidden. What am I missing?