Run VBA by clicking on a cell instead of using ActiveX Control (Command Button)

[maclachlan19]

Most of my spreadsheet are shared by a number of people that use different computer setups, different monitor resolutions and thru a Remote desktop connection.
The Command buttons I use to run some VBA often grow and shrink, often covering up the data.
I have searched and this appears to be an Excel issue.

My question is can you run VBA without using a command button. Perhaps a hyperlink in a cell of the spreadsheet.

 

[maclachlan19]

Private Sub worksheet_selectionchange(ByVal target As Range)

I tried to add the same code twice on the same sheet and ran into an error.
In the code above can selectionchange be changed to whatever I want this to be meaning I can make this selectionchange2 on my 2nd piece of code.

 

[Candyman8019]

You can use the same worksheet_selection change sub, just add another section to it like this.
If Not Intersect(Range("A3"), target) Is Nothing Then
'do something
End If

 

[Candyman8019]

To be a bit more clear…

Private Sub worksheet_selectionchange(ByVal target As Range)

If Not Intersect(Range("L5"), target) Is Nothing Then
'do something
End If

If Not Intersect(Range("A3"), target) Is Nothing Then
'do something
End If
End Sub

 

[maclachlan19]

Thanks that worked.