How to add values from userform to a table in excel worksheet

[hawaii]

Hello, I appreciate any help that I receive from you guys in advance!

My problem is this:
I am creating a grade book in excel, and have created a user form with list boxes that are populate based on assignments and student's ID #'s.

I input a number into the textbox, and I want the command button I have to enter the score into the cell of the student under the correct assignment. I am not sure what avenue to take, and any help would be appreciated. I already have the value's into variables, I just can't figure out the line of code that actually searches through the quizes for the right one, than the student id numbers.

Example

gradebook.jpg

[Norie]

You can use the Listindex property of both comboboxes to locate the row and column you want.

Something like this where I've guessed the control names.

Dim col As Long
Dim rw As Long

       col = 15+cboAssignment.ListIndex

       rw = 2 + cboStudentID.ListIndex

        Worksheets("Sheet1").Cells(rw, col).Value = Val(txtPoints.Value)

[hawaii]

Thanks, I had to make an edit to the col, but that worked exactly!!!

[Norie]

Doh, column N is column 14 not 15.