Help with GUI (for lack of a better term)

M

Mike in Saukville

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
 
J

JLatham

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
 
Top