link textbox with listbox in userform : guys i have two textbox one for search to show data from sheet to listbox and the other to show value 
what i would is any code to show value in textbox2 after show the data in list box the list box have 7 column the total value which show in textbox from the column7 automatically without any command button