I have a long list in a sheet with 4 columns. Column 1 is the names, column
2 is class #, column 3 is ID #. column 4 is city name. I want to create a
combobox, with 3 listboxes. A combobox shows number 1 to 5 and many more
later. This case is 5 classes. When I selected a number in combobox for a
class, I wanted each listbox shows correct its contents of a rows in a column
as name, ID, city. The list of each name and class will more later.

Can someone help me to code that in a userform? Thanks.
Tvnguyen

"Tvnguye" schreef in bericht
...
I have a long list in a sheet with 4 columns. Column 1 is the names,
column
2 is class #, column 3 is ID #. column 4 is city name. I want to create
a
combobox, with 3 listboxes. A combobox shows number 1 to 5 and many more
later. This case is 5 classes. When I selected a number in combobox for
a
class, I wanted each listbox shows correct its contents of a rows in a
column
as name, ID, city. The list of each name and class will more later.

Can someone help me to code that in a userform? Thanks.
Tvnguyen


Maybe it's nicer to use 1 listbox with 3 columns, instead of 3 listboxes
with 1 column each. Some listbox samples with Name, Class, ID and City are
he
http://www.geocities.com/xlsdemos/xls/LISTBOXDEMO.xls
(83kB)

Hi Moon,
Thank you very much for your help.
Your help is very wonderful. I will study your codes in both forms to apply
to my work. Probably later when I have the problems in visual basic, may I
send the question to you? Please let me know?

Thank you very much.
Tvnguye

"moon" wrote:


"Tvnguye" schreef in bericht
...
I have a long list in a sheet with 4 columns. Column 1 is the names,
column
2 is class #, column 3 is ID #. column 4 is city name. I want to create
a
combobox, with 3 listboxes. A combobox shows number 1 to 5 and many more
later. This case is 5 classes. When I selected a number in combobox for
a
class, I wanted each listbox shows correct its contents of a rows in a
column
as name, ID, city. The list of each name and class will more later.

Can someone help me to code that in a userform? Thanks.
Tvnguyen


Maybe it's nicer to use 1 listbox with 3 columns, instead of 3 listboxes
with 1 column each. Some listbox samples with Name, Class, ID and City are
he
http://www.geocities.com/xlsdemos/xls/LISTBOXDEMO.xls
(83kB)

"Tvnguye" schreef in bericht
...
Hi Moon,
Thank you very much for your help.
Your help is very wonderful. I will study your codes in both forms to
apply
to my work. Probably later when I have the problems in visual basic, may
I
send the question to you? Please let me know?

Thank you very much.
Tvnguye



Hello,

Yes, of course it's okay to send the questions.
Good luck for now.

moon

9/26/06

Hi Moon,

I thank you very much for your help last time. I learned a lot from your
help. This time I would like to add another ComboBox to show the names, and
3 TextBoxes to show correct cells of each name, such as class, ID, City. I
assume that some name is duplicated because each person can study more than
one class, and some time there are some persons with the same name. I dont
know I should use 1 or 3 TextBoxes or another way that I dont know yet, but
I hope you know the best way to do this. Also how to have the column
headings in textbox or listbox? Can you help me for this case? Thank you in
advance.
Tvnguyen


"moon" wrote:


"Tvnguye" schreef in bericht
...
Hi Moon,
Thank you very much for your help.
Your help is very wonderful. I will study your codes in both forms to
apply
to my work. Probably later when I have the problems in visual basic, may
I
send the question to you? Please let me know?

Thank you very much.
Tvnguye



Hello,

Yes, of course it's okay to send the questions.
Good luck for now.

moon

"Tvnguye" schreef in bericht
...
9/26/06

Hi Moon,

I thank you very much for your help last time. I learned a lot from your
help. This time I would like to add another ComboBox to show the names,
and
3 TextBoxes to show correct cells of each name, such as class, ID, City.
I
assume that some name is duplicated because each person can study more
than
one class, and some time there are some persons with the same name. I don't
know I should use 1 or 3 TextBoxes or another way that I don't know yet,
but
I hope you know the best way to do this. Also how to have the column
headings in textbox or listbox? Can you help me for this case? Thank you
in
advance.
Tvnguyen



Hi there again,

I updated 'your' file http://www.geocities.com/xlsdemos/xls/LISTBOXDEMO.xls
and added two more form samples. One listbox uses a rowsource (with
columnheads), the other sample uses an array to fill the list.
Please check it out, I hope it will help.


moon






"moon" wrote:


"Tvnguye" schreef in bericht
...
Hi Moon,
Thank you very much for your help.
Your help is very wonderful. I will study your codes in both forms to
apply
to my work. Probably later when I have the problems in visual basic,
may
I
send the question to you? Please let me know?

Thank you very much.
Tvnguye



Hello,

Yes, of course it's okay to send the questions.
Good luck for now.

moon