Hello,
Been playing with recorded macros followed by slight modifications for some time. I now need to try and get some information via a Userform. I use 2003 at home and 2010 at work.
I am making a "Data Entry Sheet" of Students test scores with the date of the test. A sample file I created is uploaded at -> http://www.megaupload.com/?d=GS8P6ODS
In this sheet, I enter the Date, Name, Subject & Marks. When I click "Add More Subjects", the data (all 4 information) should be stored into a temporary sheet (that pre exist --- "Temp").
In the userform, the date & student name would remain while the subject and marks fields would be cleared.the userform where it was entered. The data transferred to the "Temp" worksheet is to be displayed in the listview in the userform. I then add the next subject and marks for the same student (since the name and date fields are not cleared). When I finally click "Transfer Data", all data on the temp sheet is to be moved to the bottom of the main "Student" sheet.
For example I enter:
1/9/11 TAB Joshua TAB Science TAB 88 ........here I press "Add more Subjects". The data typed in is copied to sheet "temp" and displayed in the listview box below. At this point, the date and name remains, but the subject and marks field are cleared for me to enter Joshua's next subject and marks. I then type:
Maths TAB 99 (Since the date and name of student are still there). Again I press "Add more Subjects" and the data is moved to the temp sheet below the previous line and also appears in the listbox. Subject and Marks is again cleared. This may go on till I click "Transfer Data". When I do this, the data from the temp sheet is copied or moved to the last line of the "student" sheet.
I've got 2 other small questions, but since I really cannot do anything before this is sorted, I thought I'll ask one at a time.
I hope I have been able to explain clearly.
Thanks
Been playing with recorded macros followed by slight modifications for some time. I now need to try and get some information via a Userform. I use 2003 at home and 2010 at work.
I am making a "Data Entry Sheet" of Students test scores with the date of the test. A sample file I created is uploaded at -> http://www.megaupload.com/?d=GS8P6ODS
In this sheet, I enter the Date, Name, Subject & Marks. When I click "Add More Subjects", the data (all 4 information) should be stored into a temporary sheet (that pre exist --- "Temp").
In the userform, the date & student name would remain while the subject and marks fields would be cleared.the userform where it was entered. The data transferred to the "Temp" worksheet is to be displayed in the listview in the userform. I then add the next subject and marks for the same student (since the name and date fields are not cleared). When I finally click "Transfer Data", all data on the temp sheet is to be moved to the bottom of the main "Student" sheet.
For example I enter:
1/9/11 TAB Joshua TAB Science TAB 88 ........here I press "Add more Subjects". The data typed in is copied to sheet "temp" and displayed in the listview box below. At this point, the date and name remains, but the subject and marks field are cleared for me to enter Joshua's next subject and marks. I then type:
Maths TAB 99 (Since the date and name of student are still there). Again I press "Add more Subjects" and the data is moved to the temp sheet below the previous line and also appears in the listbox. Subject and Marks is again cleared. This may go on till I click "Transfer Data". When I do this, the data from the temp sheet is copied or moved to the last line of the "student" sheet.
I've got 2 other small questions, but since I really cannot do anything before this is sorted, I thought I'll ask one at a time.
I hope I have been able to explain clearly.
Thanks
