Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autotab
Hi,
I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") End Sub Regards Mats |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autotab
Sub TimeStamp()
ActiveCell.Value = Format(Time, "h:m ampm") ActiveCell.Offset(0, 1).Select End Sub -- Gary''s Student - gsnu200755 "Mats" wrote: Hi, I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") End Sub Regards Mats |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
autotab
Hi,
The answer to that depends on where the 'next' cell is and you don't tell us.This enters your timestamp and moves 1 cell to the right:- Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") ActiveCell.Offset(0, 1).Select End Sub Mike "Mats" wrote: Hi, I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") End Sub Regards Mats |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
autotab
Tanks!
"Mike H" wrote: Hi, The answer to that depends on where the 'next' cell is and you don't tell us.This enters your timestamp and moves 1 cell to the right:- Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") ActiveCell.Offset(0, 1).Select End Sub Mike "Mats" wrote: Hi, I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") End Sub Regards Mats |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
autotab
thanks!
"Gary''s Student" wrote: Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") ActiveCell.Offset(0, 1).Select End Sub -- Gary''s Student - gsnu200755 "Mats" wrote: Hi, I made a "short" macro with a button that is going to enter the time of day....but would also like to "autotab to next cell" for the next time stamp. How do I fix that? See code below. Sub TimeStamp() ActiveCell.Value = Format(Time, "h:m ampm") End Sub Regards Mats |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|