remember where a user has clicked

[faxof]

is there a way of storing the last three cells a user clicks on?

any ideas?
faxof

 

[Sawatzky]

dear faxof,

inform yourself about:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)


kind regards

Astrid

PS: perhaps the VBA forum would be more adequate

 

[Loomah]

Hi
This probably should have been in the VBA forum but I'm still bored so...

With a named range "History", 4 rows by 2 columns in my case and labels in the first column as follows
Now
Last
2nd Last
3rd Last
this will created a history of selected cells

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("history")
    .Cells(4, 2) = .Cells(3, 2)
    .Cells(3, 2) = .Cells(2, 2)
    .Cells(2, 2) = .Cells(1, 2)
    .Cells(1, 2) = Target.Address(False, False)
End With
End Sub

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244