I have this cmdbutton on a form
_______________________________________________
Private Sub CmdAdd_Click()
Application.ScreenUpdating = False
Set sourcewb = Workbooks.Open("path to workbook")

ActiveWorkbook.Sheets("1").Activate
Range("A1").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell) = True
ActiveCell.Value = txt1.Value
ActiveCell.Offset(0, 1) = txt2.Value
ActiveCell.Offset(0, 2) = txt3.Value

sourcewb.Close True

Unload Me

End Sub
________________________________________________

before closing the sourcewb i would like for the txt3.value to be foun
on sheet(2). if not, then another form needs to open to add txt3 t
sheet(2)

any help would be appreciated

--
Message posted from http://www.ExcelForum.com