I have a textbox1 and a listbox1 in userform1. In this textbox1, I will type a number. Upon entering the number i need help on a vba code to lookup in sheet1, sheet2 and sheet3 in column B where the number column is. If the number matches, need to lookup the following
the number that is located in column E - Sheet1,
Column D - Sheet2
Column E - Sheet 3
The number that matches should show up in the list box1.
the number that is located in column E - Sheet1,
Column D - Sheet2
Column E - Sheet 3
The number that matches should show up in the list box1.