If cndition for activecell.value in excel macro

Closed
bunty - Mar 9, 2011 at 11:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2011 at 05:31 AM
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....!!!!!!!



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 10, 2011 at 05:31 AM
Use this event of the sheet

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub
0