If cndition for activecell.value in excel macro

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need a query for excel macro ...

If I click on empty cell it has to display "no job"
If I click on any valued cell No function is occured there....!!!!!!!



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Use this event of the sheet

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub