hello, everyone

i am using a combobox in userfrom to add data to sheet

combobox range is B5:B50 and textbox range is F5:F50

for example
i have data in range b5:b50
b5 = haroon
b6 = sid
b7 = winon
b8 = excelforum

now i choose in combobox1.value = "winon" and i input some data to textbox1.value = 15
then it add the 15 to range f7
according to combobox1.selection from range

again
i choose in combobox1.value = "sid" and i input some data to textbox1.value = 7
thie it will add the 7 to range f6
according to combobox1.selection from range

now
i want if range f5:f50 have already data and i select some value in combobox1.value = haroon
then textbox automatically show textbox1.value = f5.value


thanx alot