Hi all,
How easy would it be to:
1) When a date is entered in column E, open a user form so the user can type
in names;
2) When names are all entered, when user form is closed the names are copied
to a newly created comment box in D (on the same row)?

Once names have been copied over to the comment, there is no need to save
them elsewhere.
Perhaps it would be easier to have the comment visible on screen rather than
use a user form at all and the user can then type directly into it??

Thanks,


--
Traa Dy Liooar

Jock

Right click on the Sheet tab>ViewCode and copy the below code. Try entering a
date to ColE and feedback.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
If IsDate(Target.Value) = True Then
Range("D" & Target.Row).AddComment "Enter Names"
Range("D" & Target.Row).Comment.Visible = True
End If
End If
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"Jock" wrote:

> Hi all,
> How easy would it be to:
> 1) When a date is entered in column E, open a user form so the user can type
> in names;
> 2) When names are all entered, when user form is closed the names are copied
> to a newly created comment box in D (on the same row)?
>
> Once names have been copied over to the comment, there is no need to save
> them elsewhere.
> Perhaps it would be easier to have the comment visible on screen rather than
> use a user form at all and the user can then type directly into it??
>
> Thanks,
>
>
> --
> Traa Dy Liooar
>
> Jock

Hi Jacob,
How do I get the comment to 'auto hide' once the names have been entered and
the user has moved out of the comment box?
--
Traa Dy Liooar

Jock


"Jacob Skaria" wrote:

> Right click on the Sheet tab>ViewCode and copy the below code. Try entering a
> date to ColE and feedback.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Column = 5 Then
> If IsDate(Target.Value) = True Then
> Range("D" & Target.Row).AddComment "Enter Names"
> Range("D" & Target.Row).Comment.Visible = True
> End If
> End If
> End Sub
>
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Jock" wrote:
>
> > Hi all,
> > How easy would it be to:
> > 1) When a date is entered in column E, open a user form so the user can type
> > in names;
> > 2) When names are all entered, when user form is closed the names are copied
> > to a newly created comment box in D (on the same row)?
> >
> > Once names have been copied over to the comment, there is no need to save
> > them elsewhere.
> > Perhaps it would be easier to have the comment visible on screen rather than
> > use a user form at all and the user can then type directly into it??
> >
> > Thanks,
> >
> >
> > --
> > Traa Dy Liooar
> >
> > Jock