Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use DocProps in a change declaration
Below is a change declaration I have in a sheet, is it possible to have a
similar change declaration using docProps in another cell? So when the change is made to cell "I7" the date is put in "J7" and the current author is put in "L7" I tried to copy what I have below except change = Now to = DocProps("author") and that didnt work. Private Sub Worksheet_change(ByVal Target As Range) If Not Intersect(Target, Range("I7")) Is Nothing Then Range("J7") = Now End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell back color on click | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Calculate change over time | Excel Worksheet Functions | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |