Hello, this is my first post here so I'm not sure it's in the right place - feel free to move it if necessary.
I'm currently an ESL teacher (English as a Second Language), taking a master's level course. As part of the course, candidates have to create an 'Observation Instrument' which is used to track data in ESL classes, be it from teachers, students, materials, classroom management etc. This OI is not supposed to be created on Microsoft Excel (basic Word tables are fine), but I thought that Excel would allow me to be more creative. Unfortunately, I am no expert, so I'm looking for some help.
My spreadsheet includes a table which tracks language errors and teacher corrections in ESL classes. For the 'Correction Technique' and 'Student Response' field, I would like a drop-down list to select multiple options. As far as I'm aware, Excel only allows the selection of one option for drop-down lists, so I researched a way to select multiple options. I came across a guide and played around with VBA. The table works now as I'm able to select multiple values in the drop-down list. However, if I want to edit cell J7 (the number of students), it always retains the original value of the cell. I have to delete the original value and then type in the new value to make it function properly. Presumably, this is because I've set the VBA to work fully across Column J instead of the selected cells I want. Is there a way to only allow this VBA to operate on cells J12-J30 and K12-K30?
Additionally, chances are that there will be many more than 10 errors in these classes (observations last one hour). I'm looking for a way to create a macro that creates a new blank row in the table (see rows 32-33), continuing the numbered list. Is there a way to create a macro which does this?
Thanks for any help, and let me know if anything is too confusing! I should add, that if you can help, please try to do so in the simplest way possible so I can follow, haha.
Bookmarks