ShowDataForm properties

Question

I "automatically" created a form in an excel page by highlighting the table and then clicking the form icon I have in my Quick access tool bar.

Question: Where do find the properties for this form?? If I made the form using the userform in VBA thats where it would be. To run the form I made a button and use that to call the form

Sub Edit_Data()

'

' Edit_Data Macro

'

'

    Range("A2:I10").Select

    ActiveSheet.ShowDataForm

End Sub

I want to be able to change some items.

Thanks

Rob Berridge

Answer 1

The built-in data form is fixed, you can't change it in any way.

Answer 2

Thanks for the reply. Yep, I found that out by doing a better search through the help section. I wanted to be able to send the info on the form to a printer....but I cant so thats the end of of it.