Excel Previous Selected Cell VBA [Archive]

View Full Version : Excel Previous Selected Cell VBA

Jerommeke

04-09-03, 05:47

Hey,

I want to go back to my previous selected cell, in wich I had just entered a new value. After that I want to do a control in on this entry. How do I have to take that in my VBA code (so to select that cell again)?

playernovis

04-12-03, 00:37

You can use SheetChange method. This mothod will fire everytime you make some change.....

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Row:" & Target.Row & " Column:" & Target.Column
End Sub

if you need it just for checking entered value, maybe VALIDATION would do your job.... go to TOOLS-VALIDATION or use VBA Validation Object - it's the same.

jiri