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
Bookmarks