Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create forms using microsoft excel?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i create forms using microsoft excel?
Witsend,
It depends on what you mean by forms. Some folks use a worksheet as a form into which to put data. Or you may need to make a UserForm. There you can put all kinds of text boxes, buttons that do stuff, spinners, labels, etc. Here are just the bare essentials. You go to the Visual Basic Environment (Alt-F11 from Excel). In the Project Explorer (Ctrl-R if it's not visible), right-click in your project (your workbook), and select Insert - Userform. Now use the Toolbox (View - Toolbox if it's not visible) to put controls (text boxes, buttons etc.) in it. You'll want the Properties (View - Properties) window open, to view and change properties of the userform and the controls in it. Now double-click in your userform to open a code window, and write the "code behind the form," that is, the code that will respond to user actions. In a sub (macro) somewhere in a regular code module, you cause the form to display with something like: MainMenu.Show where MainMenu is the name of the userform. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "witsend" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
how to create a dialog sheet in microsoft excel | Excel Discussion (Misc queries) | |||
Filename at the very top of Microsoft Excel Window | Excel Discussion (Misc queries) |