A Button that selects a value in a data validation drop down list based on the current sheet name

[jondavis1987]

I have formulas all tied to a data validation drop list. The dropdown list contains some of the sheet names. On those sheets I'd like to have a button that would use the sheet name the button is on to select that sheet name in the data validation dropdown list on a different sheet. The sheet with the drop down list is called "Mix Design Costs" and the list is in T1. How would I go about doing this. There are about four different sheets that I would like to have buttons on them.

 

[jondavis1987]

Figured it out.

Sub Cost_Active_Sheet()
Dim strSheetName As String
strSheetName = ActiveSheet.Name
Sheets("Mix Design Cost").Range("T1").Value = strSheetName
End Sub