(1)
you could use the selection change event - if the selection has no value
then copy from the cell above
(2)
use the right mouse click event...

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Target.Value = Target.Offset(-1, 0).Value
End Sub

"mikeburg" wrote:


When the cursor is going into a cell (when hitting the enter key), need
the cell to contain a default value of the cell above it. Kinda like
control + ' , except not be in the edit cell mode.

Any ideas?

mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=382458