Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Help with GUI (for lack of a better term)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Help with GUI (for lack of a better term)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need term for data series Gary''s Student Excel Discussion (Misc queries) 0 August 23rd 06 01:20 AM
People seeking help lack competency. Your HELP unhelpful GER Excel Discussion (Misc queries) 1 May 25th 06 03:39 PM
Nice idea lack of knowledge! carnelain Excel Discussion (Misc queries) 3 March 21st 06 08:40 PM
Do not show lack of data as a zero on graph lines, leave blank Just Joe Charts and Charting in Excel 1 February 15th 06 09:12 PM
Calculate Term Anita Excel Worksheet Functions 3 December 21st 05 05:27 AM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"