if a1 value changed then date in b1

D

DKY

I know you can do this with a worksheet function
http://tinyurl.com/97xj9
but I'm using it to track when data was input by users and its
difficult to tell them to click the "enable macros" button every time
when I can hardley explain to them how to use excel to input data. So,
to make this easier for everyone but me isn't there some way I can just
do
"if a1's data has changed then put the date in b1" Thanks in advance
for any responses.
 
J

JE McGimpsey

The first example in the URI you reference works automatically when
placed in a worksheet code module.
 
D

DKY

What exactly does the VBA part do? Keep continuous track of A1? Can
put VBA in a cell as a function
 
B

Bob Phillips

Yes but he doesn't want his users to have to enable macros, so a no-code
solution.
 
J

JE McGimpsey

Ah, I didn't get that from "I know you can do this with a worksheet
function" with a URI then pointing to two VBA solutions.
 
Top