Activate code in cell
 

Is it possible to activate code when someone clicks in a cell?

Essentially I need a calendar pop up to come up when I click in particular
cells.

Thanks
--
Steve R

Activate code in cell
 

Hello Steve,

maybe this event?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Target.Top
End Sub

But I dont know how to get a calendar...

Activate code in cell
 

I would use the Worksheet_BeforeDoubleClick.

This way users can enter a date the fast way, and call up your calendar
control

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Target.Cells.Count = 1 Then
If Target.NumberFormat = "mm/dd/yy" Then 'check for number
format
Show Calendar

Cancel = True
End If
End If
End Sub

Note you could check for a specific number format, but you could also
check for cell validation being date validation. You could also check
for a certain cell address as well.

DM Unseen

Activate code in cell
 

Look here Steve
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
Is it possible to activate code when someone clicks in a cell?

Essentially I need a calendar pop up to come up when I click in particular
cells.

Thanks
--
Steve R

Activate code in cell
 

Thanks to all, I will try them all out and let you know.
--
Steve R


"Ron de Bruin" wrote:

Look here Steve
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
Is it possible to activate code when someone clicks in a cell?

Essentially I need a calendar pop up to come up when I click in particular
cells.

Thanks
--
Steve R

Activate code in cell
 

Works a treat

Thank you very much
--
Steve R


"Ron de Bruin" wrote:

Look here Steve
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steve" wrote in message ...
Is it possible to activate code when someone clicks in a cell?

Essentially I need a calendar pop up to come up when I click in particular
cells.

Thanks
--
Steve R