sonicflash
11-29-2011, 02:35 AM
Before I get into the meat of my question I want to make sure it's even possible.
I have a log that is used to record when students arrive, leave and the total time they spent. One sheet is used for an entire semester.
Is it possible, through VBA, to have the user input the student's ID number in a form then have it display the total time to-date he/she has spent?
Also is it possible to cycle through each entry this student has and have certain information from the entry populate into text fields for review and editing?
I am very new at VBA and I think I would benefit most from an example workbook, if at all possible, so I can see the code in action.
I have a log that is used to record when students arrive, leave and the total time they spent. One sheet is used for an entire semester.
Is it possible, through VBA, to have the user input the student's ID number in a form then have it display the total time to-date he/she has spent?
Also is it possible to cycle through each entry this student has and have certain information from the entry populate into text fields for review and editing?
I am very new at VBA and I think I would benefit most from an example workbook, if at all possible, so I can see the code in action.