Private Sub CommandButton1_Click()
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.
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