using properties in text formulas

B

bill.fuhrmann

I am looking for a way to use the users name in a formula, using the
name in the Excel User Name property.

IE: I want to set up a macro that places
=Updated on " & text(now (),"MMM DD, YYYY") & " by "& {user name goes
here}
into the cell which I will then convert to a value.

I intend to do a quick check of the user name first so that if one
person does the update, it goes into one cell and anyone else's goes
into another cell.
 
A

Andy Wiggins

Put this function in a module:

Function UNAME()
UNAME = Application.UserName
End Function

In a cell put:
="Updated on "&TEXT(NOW(),"MMM DD, YYYY")&" by "&UNAME()

... and you will get something like:
Updated on Aug 29, 2006 by Andy
 
Top