View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marlene Marlene is offline
external usenet poster
 
Posts: 12
Default how do i create a form in excel?

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