open data form when worksheet opens

[Guest]

Hi there,

is there a way to auto-launch the built-in data form when the worksheet is
open?

also, is there a way to edit or add buttons or functions to the data form?

thanks!!

Em~

 

[Dave Peterson]

Option Explicit
Sub Auto_Open()

Dim wks As Worksheet
Set wks = Worksheets("Sheet1")
With wks
Application.DisplayAlerts = False
.ShowDataForm
Application.DisplayAlerts = True
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And just in case...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110462
ShowDataForm Method Fails If Data Can't Be Found

=======
And I don't think there's a way to modify those builtin forms.

But you can build your own...
Check Debra Dalgleish's site:
http://contextures.com/xlUserForm01.html

and these articles by Peter Aiken:
http://msdn2.microsoft.com/en-us/library/aa155729(office.10).aspx
http://msdn2.microsoft.com/en-us/library/aa155610(office.10).aspx

Or use one from John Walkenbach:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).