Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I was wondering if there was a way of making a note of a users actions, either from keyboard or mouse i.e. right hand mouse click | delete. I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Sheets(Environ("username")).Range("A2").Value = Empty Then Sheets(Environ("username")).Range("A2").Value = Target.Address Else Worksheets(Environ("username")).Range("A65536").En d(xlUp)(2).Value = Target.Address End If End Sub This records the cell that the user has changed so all I need now is to record the action. Is this possible? Thanks in advance. Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
Record user actions in VBA script | Excel Programming | |||
How to record Keystrokes instead of keystroke actions | Excel Programming | |||
Actions between user actions | Excel Programming | |||
Record Macro - Record custom user actions | Excel Programming |