Hi everybody,
please can anyone help me to make form to search for students by "Code" or "name" and write the tests results to be shown on the cells from "B:D" & "F:H".
sheet is attached.
thanks a lot guys in advance.
Hi everybody,
please can anyone help me to make form to search for students by "Code" or "name" and write the tests results to be shown on the cells from "B:D" & "F:H".
sheet is attached.
thanks a lot guys in advance.
Hi eltyar,
see my attachement... based on Your criteria, it should be sufficient... :-)
Contest.xlsm
Oh... I forgot to mention:
- to start recording results, pls click the button on the top of sheet
- choose to search by ID or by Name
- when you start typing in textbox, a list of matches appears on the right of it
- just click the name from the list and continue with results (it will be coppied to search textbox).
There is an option not to overwrite records if there are some of them already recorded for selected student.
If any other clarification is needed, repply to this thread
Hope it helps
Regards
M
Last edited by Miroslav R.; 05-13-2014 at 07:53 AM. Reason: Forgot to write down how it works
Hi Miroslav,
you r a superman
it's perfect
just plz small edit, can i after write the name or code and select it also selected his row on sheet to see his details, also after select him on form if he has result already recorded so i can see it on form
finally can we make another Button for "write&New"
thnx u very much again Miroslav.
also i can't move or resize or change the "Record Result" button!? how can i do that plz
Hi there,
Overview of selected student details are now on the userform, so when you select valid student name (or ID), details will appear in the bottom part of userform (no need to work with sheet).
Also I added button to userform just below search textbox. Click it and You will be able to add new student. When You finish this procedure, you are able to type this new name (or ID) in search box and record test results. But keep in mind that the search engine is done for name and ID columns, so name has to be a string and ID has to be an integer.
Students records.xlsm
And to your issue with btn resizing - that is an ActiveX button, and you are able to modify it only in 'Design Mode'.
So if you like it, do not forget to rate (little star in the left bottom corner).
Regards
M
Last edited by Miroslav R.; 05-13-2014 at 09:32 AM.
greaaaat work Miroslav thank you it's working like a charm, just you forget to add Button for "write&New" just to write the current result then empty the form to add a result for another student
finally i'm grateful for your perfect help, and i know I'm greedy but can you help me here plz for same sheet:
http://www.excelforum.com/excel-prog...nt-report.html
Regards.
Sorry.I did not get the point of write&new.but thats no problem to change. I will have a look at your print request today in the evening.
Regards
M
send from my xperia z via tapatalk
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
i have in the form now 2 button "Cancel" and "Write&Close"
just i need one more button to do "Write&New" to write the current result then empty the form to add a result for another student
Regards.
The cancel btn will be changed to close btn and from the write&close procedure I will cut userform.hide line and place clear.textbox loop.
send from my xperia z via tapatalk
great, thanks
Hi there,
sending write&clear update...
So this is final version...
Students records.xlsm
Hope You enjoy work with this file...
Regards
M
Last edited by Newmord; 05-13-2014 at 02:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks