When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run ...

To link a macro to a button in Excel, you can go through the aforementioned guide. Whether it is Excel or Word, you need to follow the same set of options. However, the aforementioned guide works ...