Mar 13 2021 01:51 PM
Mar 13 2021 02:18 PM
Do you want to change the caption of the button, i.e. the text displayed of the button? If so, you can do the following:
Right-click the sheet tab.
Select 'View Cod' from the context menu.
Copy the following code into the worksheet module:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("D1"), Target) Is Nothing Then
Buttons(1).Caption = Range("D1").Value
End If
End Sub
Change both occurrences of D1 to the cell with the dropdown.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open the workbook.
See the attached sample workbook.