Private Sub CommandButton1_Click()
Dim LastRow As Object

Range("A2").Select
ActiveSheet.ShowDataForm



End Sub

Is there a way that when i enter a new record using my data form, a ne
row is also printed?

Also how would i go about creating code for a print preveiw button?

Thank

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