View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default How to run a procedure on entering a specific cell?

Create:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
in worksheet code.

Target tells you which cell(s) have been selected.

HTH
--
AP

a écrit dans le message de
oups.com...
How to run a procedure on entering a specific cell?

I am trying to pop up a calendar control to enter a date into a
specific cell. For example: when the user moves the cursor to "B5", the
calendar control should become visible. The user then clicks on a date,
which is updated in cell "B5"

My problem is I do not know how to detect when the user selects a
specific cell in order to run the procedure. Is there a way?