I have made a sheet for entering marks and roll number database.
I want to implement search and save function in this sheet..
In this sheet if we enter number of database it can be shows in respective textbox..
for example if we enter 1 in the record number textbox....60 marks can be shown in maths mark textbox
70 can be shown in science marks textbox and so on.
I have implemented database entering formula in excel sheet through userform but i dont know how to get data from excel sheet to userform and edit/save it.so can anybody help me to coding for this function and as well as save, first record, previous record, next record , and last record button's vba code..!!???
I have attached my sheet here for reference.
Formula:
marks database.xls
Bookmarks