Dynamic Entries
Private Sub ComboBox1_Change()
If ComboBox1.Value = "a" Then
ComboBox2.RowSource = "A1:A10"
Else
ComboBox2.RowSource = "B1:B10"
End If
ComboBox2.ListIndex = 0
End Sub
--
HTH
Bob Phillips
"Richard" wrote in message
...
There is for example; combobox A where there are say 2 items. If Item #1
is
selected, then Combobox B has say 10 items to choose from. If item #2 is
selected from combobox A, then combobox B has 7 items to choose from.
Thanks,
Richard
"Tom Ogilvy" wrote:
A userform? A worksheet made to look like a paper form? what do you
mean by
Form?
How does the user make a choice?
When you say a list will appear - you mean a listbox?
The more detail you can describe, the more focused the answer will be.
--
Regards,
Tom Ogilvy
"Richard" wrote in message
...
Hello,
I am trying to make a form where there will be a choice between A and
B.
|