joanna_gr
04-13-2005, 12:43 AM
Well, it seems that I have most of pieces but still there is something misses to complete my puzzle. Here is the problem! I have a contact list and I want to create various forms with it. Till now I managed to create a form that has a combo box and shows up a name with its details in various textboxes. So far so good. Now I need to add to the form a command button to open a new form but at the same time to sort the range (B1:AO1200 = "names") by column "J" (=Companies). This new form I want to have a combo box and a listbox. The combobox should be populated with company's names (unique entries if possible). The listbox should be populated by range "names". Please notice that the column "J" is 8th on the range. The point is that after the combobox selects a company name all rows at the listbox with the same name are highlighted. And then transfer on the sheet all selections. This is the general idea i have in my mind and I hope it's clear to you. Other suggestions welcome also... :help :help :help