I am a little experienced in Excel and VB and I am setting up a user interface for my school for teachers completing a protected worksheet. The Excel worksheet has all the generated data protected and the input cells unprotected (until you date the column and save, then it locks). The first 3 cells are protected, the next 7 cells in each row are for grades and marks and the last row (8) is for a <1000 character comment. I want to create a form that has a combo box to select the student,all the other text boxes to view the other cells in that row and to enter/overwrite data into the unprotected cells.
I have created a working model, but all the linked row cells are linked to the ListIndex and only works if I squash the combo box up to one line, defeats the object, I am really stuck and would welcome any help with this.
a nice to have would be that all the cell values change as the user scrolls through the combo box