Need a little 'best method' help with a phonecall log,
where ColumnA is Date, ColumnB is Time.
I wanna be able to click on B2 and have the current time inserted, then
click on B3 and have another time inserted w/o changing B2.
I've know this has been discussed before, but Im still
confused if a
macro is needed in this simple case.
Can an event trigger be worked into a formula function or must it be
In a previous thread it was suggested to Insert/Name/Define a cell
range with a macro or function name. Will this then trigger a macro to
(ctrl + shift +or (=3DNow),
or do I need to use something more like the excerpt below;
( "Mike Fogleman Mar 18, 4:00 am show
From: "Mike Fogleman" <mikefogle...@insightbb.com> - Find messages by
Date: Fri, 18 Mar 2005 07:00:57 -0500
Local: Fri,Mar 18 2005 4:00 am
Subject: Re: Run Macro When Select Cell
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse
Private Sub Worksheet_SelectionChange(ByVa=ADl Target As Range)
If Not Application.Intersect(Range("J=AD1:J100"), Target) Is Nothing
'Call your Macro
Change the Intersect Range to whatever cell or range you want as the
This code goes in the Worksheet Module, not a general module.
Mike F ")