Pongwipat
06-17-2015, 02:01 AM
I want to listbox show data from worksheet only ID which I put in textbox1. How can I do it ?
For example : when I add 150001 in textbox1 ,listbox show
150001 jame a-city football a-movie
150001 jake c-city volleyball z-movie
150001 bake y-city basketball q-movie
150001 Ribbon f-city snooker d-movie
150001 Bander b-city snooker a-movie
150001 jame a-city football a-movie
150001 jake c-city volleyball z-movie
150001 bake y-city basketball q-movie
150001 Ribbon f-city snooker d-movie
150001 Bander b-city snooker a-movie
when I add 150002 in textbox1 ,listbox show
150002 a-name z-city basketball z-movie
150002 b-name a-city volleyball g-movie
150002 z-name b-city baseball f-movie
And,when I add 150003 in textbox1 ,listbox show
150003 david f-city swimming z-movie
150003 Kevin d-city snooker a-movie
150003 Ballock f-city baseball d-movie
150003 Bigname a-city volleyball a-movie
150003 Cassie z-city tennis b-movie
150003 Beenii g-city golf c-movie
Anyone can help or suggest?
For example : when I add 150001 in textbox1 ,listbox show
150001 jame a-city football a-movie
150001 jake c-city volleyball z-movie
150001 bake y-city basketball q-movie
150001 Ribbon f-city snooker d-movie
150001 Bander b-city snooker a-movie
150001 jame a-city football a-movie
150001 jake c-city volleyball z-movie
150001 bake y-city basketball q-movie
150001 Ribbon f-city snooker d-movie
150001 Bander b-city snooker a-movie
when I add 150002 in textbox1 ,listbox show
150002 a-name z-city basketball z-movie
150002 b-name a-city volleyball g-movie
150002 z-name b-city baseball f-movie
And,when I add 150003 in textbox1 ,listbox show
150003 david f-city swimming z-movie
150003 Kevin d-city snooker a-movie
150003 Ballock f-city baseball d-movie
150003 Bigname a-city volleyball a-movie
150003 Cassie z-city tennis b-movie
150003 Beenii g-city golf c-movie
Anyone can help or suggest?