Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change the width of a specific cell | Excel Worksheet Functions | |||
change event on specific cell rather than worksheet | Excel Discussion (Misc queries) | |||
Event macro that targets specific worksheet | Excel Discussion (Misc queries) | |||
cell change event | Excel Worksheet Functions | |||
cell value change event | Excel Worksheet Functions |