Hi everyone,
I have a problem and I ask again and again until someone hear me,pleas
help.How can i display listbox or combobox list if the source alway
change.
lets say u have textbox1,textbox2 anda listbox1
source of list box is sheet1
sheet1 too may entries by name.can be more than one entry for on
person.every day i can key in new info on sheet1it means source rang
always changes...text1 is for the name
once i type the name,how can i make excell to display all entrie
related that person(only)later if the entry is "aaaa"" next cell i
description"bla bla bla" when the list box show the lis once i clic
"aaaa"how can i make to display description on textbox2?
thanks in advance from now.I hope i will be lucky to get the answer.se


-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

If I understand your question correctly you want to use named ranges for your listbox source

That way when items are added you will get them in the list box

11/25/03 11:01AM
Hi everyone,
I have a problem and I ask again and again until someone hear me,pleasehelp.How can i display listbox or combobox list if the source alwayschange.
lets say u have textbox1,textbox2 anda listbox1
source of list box is sheet1
sheet1 too may entries by name.can be more than one entry for oneperson.every day i can key in new info on sheet1it means source rangealways changes...text1 is for the name
once i type the name,how can i make excell to display all entriesrelated that person(only)later if the entry is "aaaa"" next cell isdescription"bla bla bla" when the list box show the lis once i click"aaaa"how can i make to display description on textbox2?
thanks in advance from now.I hope i will be lucky to get the answer.seeu------------------------------------------------~~ Message posted from http://www.ExcelTip.com/~~View and post usenet messages directly from http://www.ExcelForum.com/

thks 4 the answer Steve,
but I could not get u.Now i can enter those entries by using anothe
userform.i can create a listbox item on excel pace by using address an
some other very long formulas.thats where i get lost.how can i set th
range source if in one page same person has five entries,other has onl
two.i dont want the others entries display in the list box.2nd how ca
i display the detail on text box.
thk

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com