Hi guys,

Not too sure how to explain this but I'll give it go. Basically, I need to edit a spreadsheet via a userform with 2 comboboxs acting as filters to select a certain row to edit. I have created a userform with combobox1 being the students name and combobox2 being the course . I have added a button to the userform with a textbox to add a session plan to the selected students name and selected course row (student may appear more than once on list for different courses). I hope this makes sense and someone can put me out of my misery. I have populated the comboboxs from sheet "Students" but need to know how to assign the 'session plan' Button and textbox to a cell in student sheet. Thanks