How to find the location of the previous activecell?
Appreciate the help.
MVM

Hi
one brute-force way would be to use the SelectionChange event to store the
old active cell in a static variable. what are you trying to do with this
information

--
Regards
Frank Kabel
Frankfurt, Germany
"MVM" schrieb im Newsbeitrag
...
How to find the location of the previous activecell?
Appreciate the help.
MVM

Like, if user moves from G6 to L8, you want to return a reference to
G6? You'll have to carry the reference along either in a hidden
sheet or in a variable with scope outside of a subroutine. Example:

Option Explicit

Dim sCurrentAddress As String
Dim sOldAddress As String

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
sOldAddress = sCurrentAddress
sCurrentAddress = Target.Address
MsgBox "From " & sOldAddress
End Sub

Ray at work


"MVM" wrote in message
...
How to find the location of the previous activecell?
Appreciate the help.
MVM

Thank you.
I have two columns, say C & D.
if user enters in D and C is empty, I display a message and move the active
cell in C (same row). when user enters a value in C and then enters in D and
hit RETURN key, I don't want to display the message, simply move to next row
C.

how to find I hit RETURN?
or the previous cell is in D?

is there any way to display a tool tip when user moves to column D with
empty C?

Thanks
MVM

"Frank Kabel" wrote:

Hi
one brute-force way would be to use the SelectionChange event to store the
old active cell in a static variable. what are you trying to do with this
information

--
Regards
Frank Kabel
Frankfurt, Germany
"MVM" schrieb im Newsbeitrag
...
How to find the location of the previous activecell?
Appreciate the help.
MVM