inputing items from a database list to a project list

  • Thread starter Thread starter Julian Blair
  • Start date Start date
J

Julian Blair

Is it possible to have on database list one a page and a project list
on another and add items to the project list by double clicking an
item in the database list???
 
This example assumes your database is in column A on
sheet1 and your list is on sheet 2. Double clicking in
the database copies the target value to the bottom of the
list on sheet2.

Lance

Example:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Excel.Range, Cancel As Boolean)
Application.EnableEvents = False
If Target.Parent.Name = "Sheet1" And Target.Column = 1 Then
With Worksheets("sheet2")
.Cells(Application.CountA(.Range("a:a")) + 1, 1) =
Target.Value
End With
End If
Application.EnableEvents = True
End Sub
 
Back
Top