macro for data form

[stargazer]

Must be dementia creeping up on me, but I cannot remember how to do a tiny 2 or 3 step macro for a button on a worksheet to open a data form for info entry for that worksheet. When creating the macro and getting the form for data layout of that sheet, working those steps, I can't close the form and then go to tools and stop the macro recording and have the macro run. Can someone please tell me what foolish step I'm missing? Thanks in advance. Bob

[viper]

just add userform1.show to your command button click event. this will bring up your user form for data. if you have a cancel button on your user form add unload userform1 to its click event. if you have a button on your form that posts your data to the worksheet then add unload userform1 to the end of the macro.

HTH

[James]

Private Sub CommandButton_Click()
UserForm1.Show
End Sub

Private Sub CommandButton2_Click()
UserForm1.Hide
End Sub

James