Hi,
if you put:
Private Sub CommandButton1_Click()
ActiveSheet.ShowDataForm
End Sub
in the workbook_open(), make sure a cell in the feild headings is selected, or the form won't come up right, or not at all.
oh, and I don't think you can edit the form. If someone knows a way to do this, I would REALLY like to know, I spent the last few days making an Excel database with record forms, all userforms, and it was a PAIN!
If I could have used the form feature, but customized, it would have been way faster.
HTH,
Corticus
This message was edited by Corticus on 2002-11-07 08:56
This message was edited by Corticus on 2002-11-07 09:09