View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sashi Sashi is offline
external usenet poster
 
Posts: 7
Default Change Event on a Specific Cell

I'm using data validation on one cell, say C19. Is there a pre-defined event
that we can use so that when there is a change on this specific cell it will
prompt the user for a password?

I'm new, I already have this code: (but it's not working)

Private Sub Worksheet_Change(ByVal C19 As Range)
Set pass = Application.InputBox(prompt:="Enter a Password", Type:=2)
End Sub

I found events only on workbook and worksheet but nothing on a specific
cell. Do you think this is possible? Help!