Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.