Hi everyone,
I'm trying to make a map of a classroom, with a grid representing seats. Each cell would have a students name. (so a 5*6 grid would have thirty names). What I'd to do is have a macro that allows the user to click on a name on the map. When the name is clicked I'd like the color to change. (there needs to be only one choice of colors). After I've selected however many students I need to be able to have the macro past the names of all the selected students in a column on same worksheet.
What I was thinking is that after the cells were all turned green (or whatever color) I would loop through the selected cells and copy where the interior.color = vbgree, then paste.... but I could never get it to quite work.
thanks in advance!!
I'm trying to make a map of a classroom, with a grid representing seats. Each cell would have a students name. (so a 5*6 grid would have thirty names). What I'd to do is have a macro that allows the user to click on a name on the map. When the name is clicked I'd like the color to change. (there needs to be only one choice of colors). After I've selected however many students I need to be able to have the macro past the names of all the selected students in a column on same worksheet.
What I was thinking is that after the cells were all turned green (or whatever color) I would loop through the selected cells and copy where the interior.color = vbgree, then paste.... but I could never get it to quite work.
thanks in advance!!
