Auto time freezed

[PH NEWS]

I have a long sample list, (names and telephone no.), once a name and number
are used an outcome code is entered in the end cell like so,
Column A Column B Column C Column D
Name Number Outcome

What I would like to do is have the time automatically entered in column D
once there is an entry in column C and for the time to "freeze", no matter
what other calculations take place.

[Stefi]

You can solve this with a Change event as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Range("D" & Target.Row) = Date
End If
End Sub

If you need more help on how to make an event procedure, please post!

Regards,
Stefi

„PH NEWS” ezt �*rta:

> I have a long sample list, (names and telephone no.), once a name and number
> are used an outcome code is entered in the end cell like so,
> Column A Column B Column C Column D
> Name Number Outcome
>
> What I would like to do is have the time automatically entered in column D
> once there is an entry in column C and for the time to "freeze", no matter
> what other calculations take place.
>
>
>

[PH NEWS]

Yes, please could I have more help on how to make a event procedure. Should
I be entering that in the Visual Basic?


"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> You can solve this with a Change event as follows:
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 3 Then
> Range("D" & Target.Row) = Date
> End If
> End Sub
>
> If you need more help on how to make an event procedure, please post!
>
> Regards,
> Stefi
>
> "PH NEWS" ezt �rta:
>
> > I have a long sample list, (names and telephone no.), once a name and
number
> > are used an outcome code is entered in the end cell like so,
> > Column A Column B Column C Column D
> > Name Number Outcome
> >
> > What I would like to do is have the time automatically entered in column
D
> > once there is an entry in column C and for the time to "freeze", no
matter
> > what other calculations take place.
> >
> >
> >

[Stefi]

Yes, you have to use Visual Basic:

Alt-F11 (brings up VB)
Right-click on Sheet1 in Project window (left side of the screen)
Click on View code in local menu
Click on left-side drop-down list . Choose Worksheet
Click on right-side drop-down list . Choose Change
Copy
If Target.Column = 3 Then
Range("D" & Target.Row) = Date
End If
lines between lines
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

Hope it's clear!
Regards,
Stefi

„PH NEWS” ezt �*rta:

> Yes, please could I have more help on how to make a event procedure. Should
> I be entering that in the Visual Basic?
>
>
> "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > You can solve this with a Change event as follows:
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > If Target.Column = 3 Then
> > Range("D" & Target.Row) = Date
> > End If
> > End Sub
> >
> > If you need more help on how to make an event procedure, please post!
> >
> > Regards,
> > Stefi
> >
> > "PH NEWS" ezt �*rta:
> >
> > > I have a long sample list, (names and telephone no.), once a name and
> number
> > > are used an outcome code is entered in the end cell like so,
> > > Column A Column B Column C Column D
> > > Name Number Outcome
> > >
> > > What I would like to do is have the time automatically entered in column
> D
> > > once there is an entry in column C and for the time to "freeze", no
> matter
> > > what other calculations take place.
> > >
> > >
> > >
>
>
>

[PH NEWS]

Thank you very very much, that's fantastic.

stevenL

"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:DE982AC8-1A29-4D8E-A3B5-92D84C336D6A@microsoft.com...
> Yes, you have to use Visual Basic:
>
> Alt-F11 (brings up VB)
> Right-click on Sheet1 in Project window (left side of the screen)
> Click on View code in local menu
> Click on left-side drop-down list . Choose Worksheet
> Click on right-side drop-down list . Choose Change
> Copy
> If Target.Column = 3 Then
> Range("D" & Target.Row) = Date
> End If
> lines between lines
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> End Sub
>
> Hope it's clear!
> Regards,
> Stefi
>
> "PH NEWS" ezt �rta:
>
> > Yes, please could I have more help on how to make a event procedure.
Should
> > I be entering that in the Visual Basic?
> >
> >
> > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > You can solve this with a Change event as follows:
> > >
> > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > If Target.Column = 3 Then
> > > Range("D" & Target.Row) = Date
> > > End If
> > > End Sub
> > >
> > > If you need more help on how to make an event procedure, please post!
> > >
> > > Regards,
> > > Stefi
> > >
> > > "PH NEWS" ezt �rta:
> > >
> > > > I have a long sample list, (names and telephone no.), once a name
and
> > number
> > > > are used an outcome code is entered in the end cell like so,
> > > > Column A Column B Column C Column D
> > > > Name Number Outcome
> > > >
> > > > What I would like to do is have the time automatically entered in
column
> > D
> > > > once there is an entry in column C and for the time to "freeze", no
> > matter
> > > > what other calculations take place.
> > > >
> > > >
> > > >
> >
> >
> >

[PH NEWS]

That was and is fantastic, but could you help me further. Is it possible to
add something to that entry in VB which states that if C is blank D will be
blank?


"PH NEWS" <steven.lancaster@phresearch.com> wrote in message
news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> Yes, please could I have more help on how to make a event procedure.
Should
> I be entering that in the Visual Basic?
>
>
> "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > You can solve this with a Change event as follows:
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > If Target.Column = 3 Then
> > Range("D" & Target.Row) = Date
> > End If
> > End Sub
> >
> > If you need more help on how to make an event procedure, please post!
> >
> > Regards,
> > Stefi
> >
> > "PH NEWS" ezt �rta:
> >
> > > I have a long sample list, (names and telephone no.), once a name and
> number
> > > are used an outcome code is entered in the end cell like so,
> > > Column A Column B Column C Column D
> > > Name Number Outcome
> > >
> > > What I would like to do is have the time automatically entered in
column
> D
> > > once there is an entry in column C and for the time to "freeze", no
> matter
> > > what other calculations take place.
> > >
> > >
> > >
>
>

[Stefi]

I don't understand your request clearly! If you leave column C blank, column
D also remains blank. Do you want a text in column D saying "Column C is
blank therefore column D is also blank!"?

Stefi


„PH NEWS” ezt �*rta:

> That was and is fantastic, but could you help me further. Is it possible to
> add something to that entry in VB which states that if C is blank D will be
> blank?
>
>
> "PH NEWS" <steven.lancaster@phresearch.com> wrote in message
> news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> > Yes, please could I have more help on how to make a event procedure.
> Should
> > I be entering that in the Visual Basic?
> >
> >
> > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > You can solve this with a Change event as follows:
> > >
> > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > If Target.Column = 3 Then
> > > Range("D" & Target.Row) = Date
> > > End If
> > > End Sub
> > >
> > > If you need more help on how to make an event procedure, please post!
> > >
> > > Regards,
> > > Stefi
> > >
> > > "PH NEWS" ezt �*rta:
> > >
> > > > I have a long sample list, (names and telephone no.), once a name and
> > number
> > > > are used an outcome code is entered in the end cell like so,
> > > > Column A Column B Column C Column D
> > > > Name Number Outcome
> > > >
> > > > What I would like to do is have the time automatically entered in
> column
> > D
> > > > once there is an entry in column C and for the time to "freeze", no
> > matter
> > > > what other calculations take place.
> > > >
> > > >
> > > >
> >
> >
>
>
>

[PH NEWS]

Sorry about that. What I mean is once I've made an entry in column C the
time appears in column D, which is exactly what I wanted, however when the
entry in column C is deleted I would like column D to be blank. Is there a
way of doing that?
"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:72E9DF13-C054-4D9E-AA72-716852E3352B@microsoft.com...
> I don't understand your request clearly! If you leave column C blank,
column
> D also remains blank. Do you want a text in column D saying "Column C is
> blank therefore column D is also blank!"?
>
> Stefi
>
>
> "PH NEWS" ezt �rta:
>
> > That was and is fantastic, but could you help me further. Is it possible
to
> > add something to that entry in VB which states that if C is blank D will
be
> > blank?
> >
> >
> > "PH NEWS" <steven.lancaster@phresearch.com> wrote in message
> > news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> > > Yes, please could I have more help on how to make a event procedure.
> > Should
> > > I be entering that in the Visual Basic?
> > >
> > >
> > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > > You can solve this with a Change event as follows:
> > > >
> > > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > > If Target.Column = 3 Then
> > > > Range("D" & Target.Row) = Date
> > > > End If
> > > > End Sub
> > > >
> > > > If you need more help on how to make an event procedure, please
post!
> > > >
> > > > Regards,
> > > > Stefi
> > > >
> > > > "PH NEWS" ezt �rta:
> > > >
> > > > > I have a long sample list, (names and telephone no.), once a name
and
> > > number
> > > > > are used an outcome code is entered in the end cell like so,
> > > > > Column A Column B Column C Column D
> > > > > Name Number Outcome
> > > > >
> > > > > What I would like to do is have the time automatically entered in
> > column
> > > D
> > > > > once there is an entry in column C and for the time to "freeze",
no
> > > matter
> > > > > what other calculations take place.
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
> >

[Stefi]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Range("D" & Target.Row) = IIf(Target.Value = "", "", Date)
End If
End Sub


Regards,
Stefi

„PH NEWS” ezt �*rta:

> Sorry about that. What I mean is once I've made an entry in column C the
> time appears in column D, which is exactly what I wanted, however when the
> entry in column C is deleted I would like column D to be blank. Is there a
> way of doing that?
> "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> news:72E9DF13-C054-4D9E-AA72-716852E3352B@microsoft.com...
> > I don't understand your request clearly! If you leave column C blank,
> column
> > D also remains blank. Do you want a text in column D saying "Column C is
> > blank therefore column D is also blank!"?
> >
> > Stefi
> >
> >
> > "PH NEWS" ezt �*rta:
> >
> > > That was and is fantastic, but could you help me further. Is it possible
> to
> > > add something to that entry in VB which states that if C is blank D will
> be
> > > blank?
> > >
> > >
> > > "PH NEWS" <steven.lancaster@phresearch.com> wrote in message
> > > news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> > > > Yes, please could I have more help on how to make a event procedure.
> > > Should
> > > > I be entering that in the Visual Basic?
> > > >
> > > >
> > > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > > > You can solve this with a Change event as follows:
> > > > >
> > > > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > > > If Target.Column = 3 Then
> > > > > Range("D" & Target.Row) = Date
> > > > > End If
> > > > > End Sub
> > > > >
> > > > > If you need more help on how to make an event procedure, please
> post!
> > > > >
> > > > > Regards,
> > > > > Stefi
> > > > >
> > > > > "PH NEWS" ezt �*rta:
> > > > >
> > > > > > I have a long sample list, (names and telephone no.), once a name
> and
> > > > number
> > > > > > are used an outcome code is entered in the end cell like so,
> > > > > > Column A Column B Column C Column D
> > > > > > Name Number Outcome
> > > > > >
> > > > > > What I would like to do is have the time automatically entered in
> > > column
> > > > D
> > > > > > once there is an entry in column C and for the time to "freeze",
> no
> > > > matter
> > > > > > what other calculations take place.
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > >
> > >
> > >
>
>
>

[PH NEWS]

B - E - A - Utiful. Thank you very much for your help
"Stefi" <Stefi@discussions.microsoft.com> wrote in message
news:EB2DD892-33B3-46B3-8AB0-505440C4CD36@microsoft.com...
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 3 Then
> Range("D" & Target.Row) = IIf(Target.Value = "", "", Date)
> End If
> End Sub
>
>
> Regards,
> Stefi
>
> "PH NEWS" ezt �rta:
>
> > Sorry about that. What I mean is once I've made an entry in column C the
> > time appears in column D, which is exactly what I wanted, however when
the
> > entry in column C is deleted I would like column D to be blank. Is there
a
> > way of doing that?
> > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > news:72E9DF13-C054-4D9E-AA72-716852E3352B@microsoft.com...
> > > I don't understand your request clearly! If you leave column C blank,
> > column
> > > D also remains blank. Do you want a text in column D saying "Column C
is
> > > blank therefore column D is also blank!"?
> > >
> > > Stefi
> > >
> > >
> > > "PH NEWS" ezt �rta:
> > >
> > > > That was and is fantastic, but could you help me further. Is it
possible
> > to
> > > > add something to that entry in VB which states that if C is blank D
will
> > be
> > > > blank?
> > > >
> > > >
> > > > "PH NEWS" <steven.lancaster@phresearch.com> wrote in message
> > > > news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> > > > > Yes, please could I have more help on how to make a event
procedure.
> > > > Should
> > > > > I be entering that in the Visual Basic?
> > > > >
> > > > >
> > > > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > > > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > > > > You can solve this with a Change event as follows:
> > > > > >
> > > > > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > > > > If Target.Column = 3 Then
> > > > > > Range("D" & Target.Row) = Date
> > > > > > End If
> > > > > > End Sub
> > > > > >
> > > > > > If you need more help on how to make an event procedure, please
> > post!
> > > > > >
> > > > > > Regards,
> > > > > > Stefi
> > > > > >
> > > > > > "PH NEWS" ezt �rta:
> > > > > >
> > > > > > > I have a long sample list, (names and telephone no.), once a
name
> > and
> > > > > number
> > > > > > > are used an outcome code is entered in the end cell like so,
> > > > > > > Column A Column B Column C Column D
> > > > > > > Name Number Outcome
> > > > > > >
> > > > > > > What I would like to do is have the time automatically entered
in
> > > > column
> > > > > D
> > > > > > > once there is an entry in column C and for the time to
"freeze",
> > no
> > > > > matter
> > > > > > > what other calculations take place.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„PH NEWS” ezt �*rta:

> B - E - A - Utiful. Thank you very much for your help
> "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> news:EB2DD892-33B3-46B3-8AB0-505440C4CD36@microsoft.com...
> > Private Sub Worksheet_Change(ByVal Target As Range)
> > If Target.Column = 3 Then
> > Range("D" & Target.Row) = IIf(Target.Value = "", "", Date)
> > End If
> > End Sub
> >
> >
> > Regards,
> > Stefi
> >
> > "PH NEWS" ezt �*rta:
> >
> > > Sorry about that. What I mean is once I've made an entry in column C the
> > > time appears in column D, which is exactly what I wanted, however when
> the
> > > entry in column C is deleted I would like column D to be blank. Is there
> a
> > > way of doing that?
> > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > news:72E9DF13-C054-4D9E-AA72-716852E3352B@microsoft.com...
> > > > I don't understand your request clearly! If you leave column C blank,
> > > column
> > > > D also remains blank. Do you want a text in column D saying "Column C
> is
> > > > blank therefore column D is also blank!"?
> > > >
> > > > Stefi
> > > >
> > > >
> > > > "PH NEWS" ezt �*rta:
> > > >
> > > > > That was and is fantastic, but could you help me further. Is it
> possible
> > > to
> > > > > add something to that entry in VB which states that if C is blank D
> will
> > > be
> > > > > blank?
> > > > >
> > > > >
> > > > > "PH NEWS" <steven.lancaster@phresearch.com> wrote in message
> > > > > news:43e9e024$0$29563$da0feed9@news.zen.co.uk...
> > > > > > Yes, please could I have more help on how to make a event
> procedure.
> > > > > Should
> > > > > > I be entering that in the Visual Basic?
> > > > > >
> > > > > >
> > > > > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > > > > news:00D62B5A-8B2A-4E49-9DC4-7CFD53454FF1@microsoft.com...
> > > > > > > You can solve this with a Change event as follows:
> > > > > > >
> > > > > > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > > > > > If Target.Column = 3 Then
> > > > > > > Range("D" & Target.Row) = Date
> > > > > > > End If
> > > > > > > End Sub
> > > > > > >
> > > > > > > If you need more help on how to make an event procedure, please
> > > post!
> > > > > > >
> > > > > > > Regards,
> > > > > > > Stefi
> > > > > > >
> > > > > > > "PH NEWS" ezt �*rta:
> > > > > > >
> > > > > > > > I have a long sample list, (names and telephone no.), once a
> name
> > > and
> > > > > > number
> > > > > > > > are used an outcome code is entered in the end cell like so,
> > > > > > > > Column A Column B Column C Column D
> > > > > > > > Name Number Outcome
> > > > > > > >
> > > > > > > > What I would like to do is have the time automatically entered
> in
> > > > > column
> > > > > > D
> > > > > > > > once there is an entry in column C and for the time to
> "freeze",
> > > no
> > > > > > matter
> > > > > > > > what other calculations take place.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

[abdulla]

Hi,

im in a big problem and i need your help to solve it.
when i use function "=now()" on excel it returns the current time and i want to save this time autmatically in another coulum (to prevent its automatically update) that it will not change again.
manually i can do it by Copy and Paste as value but i need to make this automtically also without using Macro. or if you tell me how to activate (Ctrl+shift+semi-colon) without pressing them on keyboard.



best regards,
Abdulla