List Box Selection / Highligh Selection Code

[Dr.SUN]

Dear Experts,

I in our factory we are using material stocks in excel for that i have attached file Sheet( Data2) if i select a material code like xx04 in the list box, automatically it should highlight below what i have selected code...........

Please find attached file and help me reg this.

Regards
Dr.Sun

[royUK]

There's no code in the example

Why not just use AutoFilter?

[Dr.SUN]

pls see the sheet data2 in the list box i have selected one code it should be slected below automatically in the yellow

[Dr.SUN]

anyone there to help me ..........................................

[Dr.SUN]

let me know roy pls try on this and help me

[LucB]

Hope this helps.

Please Login or Register  to view this content.

[Dr.SUN]

but it should highligt what i have slected if i select next it should highlight that only but not the previous one should highlight i dont know how to explain i think u understand................