Question : vba sub assigned to cell
Answered by : powerful-partridge-57umjvotqtv7
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then Call YourMacroNameHere 'amend the address to the be cell you want, and YourmAcroNameHere to be the macro you want to activate
End Sub
Source : https://www.mrexcel.com/board/threads/assign-macro-to-a-cell.404094/ | Last Update : Sun, 21 Mar 21