PDA

View Full Version : VBA USERFORM : listbox show data only ID selected



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?

paulked
06-17-2015, 06:06 AM
13715

paulked
06-17-2015, 06:45 AM
13716

Pongwipat
06-19-2015, 07:14 AM
Thank you so much