Are form buttons in a cell?

[dmt]

When I create a form button they seem to float "above" the cells. Are they associated with a specific cell? Or can I make them that way? So that when I click on it it checks what cell it is in and then uses that information?

Or maybe I'm trying to do this the wrong way.

Here is what I want to do. I have a workbook with something like 30 identical pages, each one for a different person (students actually). On each page I want to create a list of student goals so I can keep track of which goals have been reached or not reached.

Most of the time all the students will reach a goal and only a few won't, so I would like to be able to set a goal from a drop down list as "reached" and then copy that value to all the rest in that same cell. Then I could go by hand and change the few left that haven't reached the goal (this seems the easiest way to me).

The only way I can think of doing this is having a button next to each goal that will copy the value of that goal to all the other pages when pressed. But I don't want to have to hard code every individual button, (there will be a lot), so it seems easier to have some generic method that sees where it is, then they would all have the same code.

Is there some easier way to do this? I was planning on using Data Validation list for the cell to make it simple and not any kind of combo box from a form or anything.

[Mordred]

Buttons are not in a cell, they float. As for using buttons across your workbook, you will have to code them all but you could have a macro that does specifically what you want with regards to the data you want to transfer. With a macro made for that you just have to call that macro within each button. Example:

Please Login or Register  to view this content.

where nameOfMacro is the the macro designed to copy goal values.
Repeat for each sequential button.

[DonkeyOte]

re: Form Buttons see a not too dissimilar thread from earlier on today

Whether you should be using Buttons - no I would suggest not.

If the cells containing the "goals" are located in identical cells across all sheets (as I suspect they are) then simply Group the sheets before making the change.
(remember to ungroup thereafter - note too per link above you could group a handful of sheets to revert the status of those exceptions to the rule)