Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you very much for your detailed response. I was hoping for more of an
Excel-Froms for Dummies" version, but I do appreciate your help!!! "FSt1" wrote: hi bring up the vb editor. Alt+F11 one the menu bar.....Insertuser form. The tool box should appear beside it. start designing. you will need code to show the form on the sheet. Sub mac1frmRRShow() 'change frmRR to the name of your form Load frmRR frmRR.Show 0 ' the zero show if form is modal or not. if modal, you have to 'enter data and close the form before you can do anything else AppActivate Application.Caption End Sub You will need an initialization sub also. a lot of help in vb help. good luck FSt1 "Marlene" wrote: I can find plenty of help on designing and tweaking a form, but how do you actually create one? I am using Excel 2003. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a form in Excel? | Excel Worksheet Functions | |||
Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
How do I create a database from an Excel form? | Excel Discussion (Misc queries) | |||
How do I create a form in Excel? | Excel Discussion (Misc queries) |