LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 336
Default Record Actions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open new record with selected fields from previous record Design by Sue Excel Discussion (Misc queries) 1 June 12th 09 02:24 PM
Record user actions in VBA script papal02 Excel Programming 0 July 23rd 07 03:48 PM
How to record Keystrokes instead of keystroke actions DonD''Cajun Excel Programming 3 April 5th 07 02:31 PM
Actions between user actions Indiana Epilepsy and Child Neurology[_2_] Excel Programming 5 August 23rd 06 09:22 PM
Record Macro - Record custom user actions Sal[_4_] Excel Programming 1 December 23rd 04 03:18 PM


All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"