How to show history to specific value

[Ed_Filipino]

Hi gudpm again, After my first useform I got excited to create and develop another one which can be useful more likely in my work.

For example I have a spreadsheet like this

Machine REPAIR DETAILS DATE MECHANIC PARTS USED

M1 replaced battery 1/1/2000 JOHN DOE BATTERY



SO as the time goes by the sheet became bigger and wider what I am planning is to create a text box for every coluimn heading and when you type any of them details linking to that value will appear on a big list box below

can you help me to guide especially for the macro codes.

 

[Ed_Filipino]

Maybe all of you guys were confuse sorry for my English was not that gud... I have a six column table in excel
MACHINE/ TYPE /REPAIR DETAILS /DATE /MECHANIC /PARTS USED

I AM PLANNING TO CREATE A USERFORM USING 1 TEXTBOX AND 1 LISTBOX

TEXTBOX WILL BECOME THE SEARCH BOX
LISTBOX WILL SHOW DETAILS PERTAINING TO THE VALUE ENTERED IN THE TEXT BOX WHATEVER TO THE 6 "COLUMN VALUE" IT WILL BE AND AS MUCH AS POSIIBLE IT WILL SHOW TOGETHER THE COMPLETE ROW WHERE THE "COLUMN VALUE" WAS ALLOCATED.


HOPE YOU CAN HELP ME SET UP MY NEW USERFORM THAT I CAN ALSO SHARE TO SOME OF MY COLLEAGUES.

FOR NOW ADVVANCE THANK YOU AND MAY GOD BLESS YOU ALL!!!!