Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
after entering a text in one cell, next cell should disp the entd
how to do ? after entering a text in one cell, next cell should disp the entd
time |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
after entering a text in one cell, next cell should disp the entd
You can use the change event. The following macro, for example, will look
for changes to any cell in column A and record the date/time in column B: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub End If Target.Offset(0, 1).Value = Now End Sub -- Gary''s Student - gsnu200737 "Sridhar" wrote: how to do ? after entering a text in one cell, next cell should disp the entd time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you do hard returns in 1 cell? entering address in 1 cell | Excel Discussion (Misc queries) | |||
Entering a number in any cell eg. 1 it changes to 0.01 why | Excel Discussion (Misc queries) | |||
text in a cell upon entering the cell | Excel Discussion (Misc queries) | |||
What is the Chr() code for Alt+Enter in a cell when entering text? | Excel Discussion (Misc queries) | |||
how to rec/disp. file name in a w/s cell with a funtion (Auto) | Excel Discussion (Misc queries) |