Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
Gentlemen,
I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
Launch VBE using Alt+F11. From the left treeview double click Sheet1. From
drop down select Worksheet Change and paste the code so as look as below... Try in Sheet1 ColA Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A:$A")) Is Nothing Then Range("B" & Target.Row) = Now() End If End Sub -- If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: Gentlemen, I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
Two follow up comments (for Gunter's consideration)...
1) You can also go directly to the code window for Sheet1 (or any sheet for that matter) by right clicking the sheet's tab and selecting View Code from the popup menu that appears. 2) There is no need for Gunter to click the drop downs and select Worksheet and Change as your posted code already has the procedure framework that doing so produces. All Gunter needs to do is popup the code window (using either your posted method or #1 above) and copy/paste your posted code into that code window. -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Launch VBE using Alt+F11. From the left treeview double click Sheet1. From drop down select Worksheet Change and paste the code so as look as below... Try in Sheet1 ColA Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A:$A")) Is Nothing Then Range("B" & Target.Row) = Now() End If End Sub -- If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: Gentlemen, I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
I probably not doing something right.
As Rick Rothstein explained I right clicked on sheet tab - and selected View Code - in VBA pasted the code and saved the script. When I tested in excel nothing happens. I entered text in A1 but nothing shows up in B1. What am I doing wrong, or is the timestamp hidden? "Rick Rothstein" wrote: Two follow up comments (for Gunter's consideration)... 1) You can also go directly to the code window for Sheet1 (or any sheet for that matter) by right clicking the sheet's tab and selecting View Code from the popup menu that appears. 2) There is no need for Gunter to click the drop downs and select Worksheet and Change as your posted code already has the procedure framework that doing so produces. All Gunter needs to do is popup the code window (using either your posted method or #1 above) and copy/paste your posted code into that code window. -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Launch VBE using Alt+F11. From the left treeview double click Sheet1. From drop down select Worksheet Change and paste the code so as look as below... Try in Sheet1 ColA Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A:$A")) Is Nothing Then Range("B" & Target.Row) = Now() End If End Sub -- If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: Gentlemen, I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
Please set the security level to low/medium in (Tools|Macro|Security).
If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: I probably not doing something right. As Rick Rothstein explained I right clicked on sheet tab - and selected View Code - in VBA pasted the code and saved the script. When I tested in excel nothing happens. I entered text in A1 but nothing shows up in B1. What am I doing wrong, or is the timestamp hidden? "Rick Rothstein" wrote: Two follow up comments (for Gunter's consideration)... 1) You can also go directly to the code window for Sheet1 (or any sheet for that matter) by right clicking the sheet's tab and selecting View Code from the popup menu that appears. 2) There is no need for Gunter to click the drop downs and select Worksheet and Change as your posted code already has the procedure framework that doing so produces. All Gunter needs to do is popup the code window (using either your posted method or #1 above) and copy/paste your posted code into that code window. -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Launch VBE using Alt+F11. From the left treeview double click Sheet1. From drop down select Worksheet Change and paste the code so as look as below... Try in Sheet1 ColA Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A:$A")) Is Nothing Then Range("B" & Target.Row) = Now() End If End Sub -- If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: Gentlemen, I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for Timestamp
Thank you,
It is working great! Guntars "Jacob Skaria" wrote: Please set the security level to low/medium in (Tools|Macro|Security). If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: I probably not doing something right. As Rick Rothstein explained I right clicked on sheet tab - and selected View Code - in VBA pasted the code and saved the script. When I tested in excel nothing happens. I entered text in A1 but nothing shows up in B1. What am I doing wrong, or is the timestamp hidden? "Rick Rothstein" wrote: Two follow up comments (for Gunter's consideration)... 1) You can also go directly to the code window for Sheet1 (or any sheet for that matter) by right clicking the sheet's tab and selecting View Code from the popup menu that appears. 2) There is no need for Gunter to click the drop downs and select Worksheet and Change as your posted code already has the procedure framework that doing so produces. All Gunter needs to do is popup the code window (using either your posted method or #1 above) and copy/paste your posted code into that code window. -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Launch VBE using Alt+F11. From the left treeview double click Sheet1. From drop down select Worksheet Change and paste the code so as look as below... Try in Sheet1 ColA Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("$A:$A")) Is Nothing Then Range("B" & Target.Row) = Now() End If End Sub -- If this post helps click Yes --------------- Jacob Skaria "Guntars" wrote: Gentlemen, I am new to VBA, what I am trying to achieve is, for example when I enter a text in cell A1 I want VBA script automatically put timestamp in a cell B1 and so on. There will be more text added later in column A, and I always want the timestamp to appear right next to it, in column B. I hope somebody will be able to help me, and also explain the steps how its done. Thank you, Guntars |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform code for timestamp on w/sheet | Excel Programming | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp | Excel Discussion (Misc queries) | |||
timestamp on each row... | Excel Programming | |||
timestamp | Excel Programming |