Looking at setting up a suite of buttons for navigating to various places in a workbook. Buttons will be drawn Bevel shapes.
I am looking to write one macro that will be assigned to all buttons with various Case Select statements dependent on which button is clicked.
How do I pull the Text value from the button to determine which one has been clicked?
I am fairly sure this can be done as I have seen and used it before but don't recall how.