Userform in excel
 

I want to build a userform containing at least 5 combo boxes besides
other controls.The userform should load data from sheet1 and what ever
the user has selected should be saved in sheet2.The Value of combo2
should populate after selecting combo1 and combo3 should populate after
Combo2 is done and so on.
Also is it possible to show multiple values the user selects from
select lists in a text box/text area and he should be able to select
/deselect the values from this text box/ area.
Any quick response with examples will be a great help to me.
Thanks.

Userform in excel
 

You are not going to get a quick response, and it is quite long-winded, and
what have you done to date?

First combobox is simple, just set the list link to the range on sheet 1.
Dependent comboboxes are quite straightforward, but need code to make the
decision as to what is populated in there, as with the others.

I would suggest a Listbox to store the selected values, that can also be
selected from.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ST" wrote in message
oups.com...
I want to build a userform containing at least 5 combo boxes besides
other controls.The userform should load data from sheet1 and what ever
the user has selected should be saved in sheet2.The Value of combo2
should populate after selecting combo1 and combo3 should populate after
Combo2 is done and so on.
Also is it possible to show multiple values the user selects from
select lists in a text box/text area and he should be able to select
/deselect the values from this text box/ area.
Any quick response with examples will be a great help to me.
Thanks.

Userform in excel
 

This example in VBAExpress might help get you started

http://vbaexpress.com/forum/attachme...p;d=1152742444

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bob Phillips" wrote in message
...
You are not going to get a quick response, and it is quite long-winded,
and
what have you done to date?

First combobox is simple, just set the list link to the range on sheet 1.
Dependent comboboxes are quite straightforward, but need code to make the
decision as to what is populated in there, as with the others.

I would suggest a Listbox to store the selected values, that can also be
selected from.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ST" wrote in message
oups.com...
I want to build a userform containing at least 5 combo boxes besides
other controls.The userform should load data from sheet1 and what ever
the user has selected should be saved in sheet2.The Value of combo2
should populate after selecting combo1 and combo3 should populate after
Combo2 is done and so on.
Also is it possible to show multiple values the user selects from
select lists in a text box/text area and he should be able to select
/deselect the values from this text box/ area.
Any quick response with examples will be a great help to me.
Thanks.