Cell contain default value of cell above it
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 |
Cell contain default value of cell above it
(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 |
Cell contain default value of cell above it
Use data validation:
Select column to validate e.g. E select Data-validation,tyep List, now type formula: =OFFSET(E1,-1,0). DM Unseen |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com