if a1 value changed then date in b1

[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.

 

[Anne Troy]

Not without VBA.
*******************
~Anne Troy

www.OfficeArticles.com

 

[JE McGimpsey]

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

 

[DKY]

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

 

[Bob Phillips]

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

 

[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.