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

Any ideas?

mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=38245

(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

Use data validation:

Select column to validate e.g. E select Data-validation,tyep List, now
type formula: =OFFSET(E1,-1,0).

DM Unseen