Hello all,
I am using excel 2000 on a win98se machine.
I have a macro created to launch a form with the code below:
Private Sub UserForm_Initialize()
Dim TitleTxt As String
TitleTxt = "Fulltime"
With Me.ComboBox1
.AddItem "Fulltime"
.AddItem "Partime"
.Text = TitleTxt
End With
End Sub
Here's my question:
I'd like to add another dropdown box on the same form however, depending upon which entry above is selected, ("Fulltime" or "Partime") the contents of the second box would change. For example, if the user select "Fulltime", I'd like the choices of the second box to be "Monday" and "Friday". And if they select "Partime" from the first box, I'd like the choices of the second box to be "Saturday" and "Sunday".
Any help will be greatly appreciated.
Thanks,
Jamie
I am using excel 2000 on a win98se machine.
I have a macro created to launch a form with the code below:
Private Sub UserForm_Initialize()
Dim TitleTxt As String
TitleTxt = "Fulltime"
With Me.ComboBox1
.AddItem "Fulltime"
.AddItem "Partime"
.Text = TitleTxt
End With
End Sub
Here's my question:
I'd like to add another dropdown box on the same form however, depending upon which entry above is selected, ("Fulltime" or "Partime") the contents of the second box would change. For example, if the user select "Fulltime", I'd like the choices of the second box to be "Monday" and "Friday". And if they select "Partime" from the first box, I'd like the choices of the second box to be "Saturday" and "Sunday".
Any help will be greatly appreciated.
Thanks,
Jamie