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.
Should option A be selected within the form, I need a list to appear - say
options 1-10; should B be selected, I need a different list to appear.
Can
anybody shed some insight please?

Thanks in advance,
Richard