I want to run code based on a particular chosen cells

[azizrasul]

I want to run code based on a particular chosen cells on a particular sheet. For example if the cell $H$21 is chosen then run some code but if cell $H$22 is chosen then run some other code.

Something like:

If $H$21 Then
run some code
ElseIf $H$22 Then
run some other code
end if

 

[jim may]

Check out the Event code behind your worksheet. Target=the Address of Your Selected Cell

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub

 

[azizrasul]

Thanks Jim.