matthew230
Board Regular
- Joined
- Jan 2, 2006
- Messages
- 152
Hi
I am having my first goes at Userforms. I have the below code to add items to a combo box when an alternative combo box has its selection made. However it is throwing up errors if the user selects one option and then the other. Is there a piece of code to remove all items first ??
Thanks
Matt
I am having my first goes at Userforms. I have the below code to add items to a combo box when an alternative combo box has its selection made. However it is throwing up errors if the user selects one option and then the other. Is there a piece of code to remove all items first ??
Code:
Private Sub Comoffice_Change()
If Comoffice = "Kettering" Then
With Comrate
.AddItem "Kett Social - Urban"
.AddItem "Kett Private"
End With
ElseIf Comoffice = "Leamington" Then
With Comoffice
.AddItem "Leam Social - Urban"
.AddItem "Leam - Private"
End With
End If
End Sub
Thanks
Matt