If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Forms using VBA
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 |
#2
|
|||
|
|||
Hi Suzi
http://support.microsoft.com/default...b;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...&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 -- Regards Ron de Bruin http://www.rondebruin.nl "Suzi" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Mail Merge for Creating a Document of Biographies... | Sam Clarke | General Discussion | 1 | January 4th, 2005 04:28 PM |
Creating forms; drop down lists | harry | General Discussion | 1 | December 8th, 2004 06:45 PM |
Creating forms that allow "fill-in" areas, but keeps other text f. | H | General Discussion | 2 | November 8th, 2004 03:48 PM |
creating forms with more then three tables | Mick | New Users | 5 | August 18th, 2004 06:04 PM |
creating controls on open forms | Kenneth_J | Setting Up & Running Reports | 0 | June 23rd, 2004 06:44 PM |