Hello, I am new to VBA but am trying to create a userform that will guide people through data entry.
The current Userform has 2 comboboxes and 2 Labels, but one label is contextual.
The second combobox gives appropriate options depending on what the user selected in the first. My problem is I want the contextual label to update automatically (without having to click it) depending on what the user selected in the first combobox.
I think it might be a repaint function, but thus far I haven't been able to get it to work.
I greatly appreciate any help! Thank you!
Private Sub Add1_Click()
End Sub
Private Sub Label1_Click()
If Me.cboAdd1 = "Product" Then
Me.Label1 = "Please Select the appropriate Company"
ElseIf Me.cboAdd1 = "Resin" Then
Me.Label1 = "Please Select the appropriate Resin type"
End If
End Sub
Private Sub cboAdd1_Change()
If Me.cboAdd1 = "Product" Then
Me.cboSpecific.RowSource = "=Aero"
ElseIf Me.cboAdd1 = "Resin" Then
Me.cboSpecific.RowSource = "=Resin"
End If
End Sub
Private Sub cboSpecific_Change()
End Sub
Private Sub UserForm_Click()
End Sub
Bookmarks