Creating Forms using VBA

[Guest]

I would like to create data entry forms with buttons that enable Find
Previous, Find Next and New (as appear on the standard microsoft form). I
can create the forms in VBA and enter data from the form into the worksheet.
Can anyone help with coding for the other functions?

A level students are creating these forms, using the standard microsoft form
doesn't allow them to show their skills - creating their own does, so using
the standard form isn't an option. (excel 2003)

Thanks

 

[Ron de Bruin]

Hi Suzi

http://support.microsoft.com/default.aspx?scid=kb;EN-US;829070
How to use Visual Basic for Applications (VBA) to change UserForms in Excel 2003, Excel 2002, and Excel 2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;168067&Product=xlw97
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://www.j-walk.com/ss/excel/tips/userformtips.htm

And this great Add-in (much better then Excel's DataForm)
http://www.j-walk.com/ss/dataform/index.htm