I am creating an Excel sheet of an NCAA tournament bracket, and I want to make it so that when you click on the cell with the team you think will win, the name of that team will advance to the next round. I was told that I could make a button, assign a macro to it, and then put the button over the corresponding cell. However, I don't want to see the button, but rather the text in the cell behind the button. When I make the button invisible, I can't click the button. Also, when I click the button, all my keystrokes are replayed (obviously), but that makes my bracket look glitchy. Any ideas on how I can make the button clickable and invisible at the same time? Or is there a better solution to my problem?

Sorry... cannot help you with the code, know very little about VBA.

Would like to see the excel file though.

A friend of mine runs a pool every year for the tournament, and he may be interested in it.

A macro to move values from cell to cell is pretty basic. A button shouldn't be necessary, the macro can be triggered by any number of methods (hotkey, doubleclick event, etc).

But the macro itself would be very structured to your actual sheet. I wouldn't know what was appropriate to suggest without seeing the workbook.

Upload a copy of your workbook here with clear BEFORE/AFTER examples as necessary.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.