hi,
this is a database, try to play with it and u'll see how it works.
'---------------------------------------------------------------------------------------
' Module    : Database Form
' DateTime  : 31/08/2005 10:55. Updatede 08-02-08
' Author    : Roy Cox
' Purpose   : Data entry form for Excel, with Search facility
'---------------------------------------------------------------------------------------
Dim MyData     As Range
Dim c          As Range
Dim rFound     As Range
Dim r          As Long
Dim rng        As Range
Const frmMax   As Long = 320
Const frmHt    As Long = 210
Const frmWidth As Long = 280
Dim sFileName  As String        'image name
Dim oCtrl      As MSForms.Control

Private Sub cmbAdd_Click()
'
'
john