Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have made a database in Excell 2002. I would like to make a form or a
"dummy page" that will display the fields of the worksheet so that I can enter the data from there. I think it will look more professional. I am looking to make a form that is similar to the way you can make a form in Access to "overlay" the database. I dont know if there is a template for this or how to proceed. thanx for the help in advance |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel has a form similar to that in Access. You get to them to create them
through the Visual Basic Editor in Excel. Press [Alt]+[F11] to get into the VB Editor. Then use Insert | UserForm and a new form will be displayed. You can start from there. There are two 'views' of a form/controls on it: the object itself (as the form) or the code associated with the object (form or control on the form). Once you get it designed you have to figure a way to get it to appear for the user to see and use. You will need a macro activated somehow that (assuming your form is named UserForm1) cause the form to display. The code for that is simple UserForm1.Show and in your form, when you want it to go away is UserForm1.Hide "Mike in Saukville" wrote: I have made a database in Excell 2002. I would like to make a form or a "dummy page" that will display the fields of the worksheet so that I can enter the data from there. I think it will look more professional. I am looking to make a form that is similar to the way you can make a form in Access to "overlay" the database. I dont know if there is a template for this or how to proceed. thanx for the help in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need term for data series | Excel Discussion (Misc queries) | |||
People seeking help lack competency. Your HELP unhelpful | Excel Discussion (Misc queries) | |||
Nice idea lack of knowledge! | Excel Discussion (Misc queries) | |||
Do not show lack of data as a zero on graph lines, leave blank | Charts and Charting in Excel | |||
Calculate Term | Excel Worksheet Functions |