how do i create a form in excel?

[Guest]

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

 

[Guest]

hi
bring up the vb editor. Alt+F11
one the menu bar.....Insert>user 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

 

[Otto Moehrbach]

Don't know what you mean. The act of designing a form is the same as
creating a form. Maybe I'm missing something. Post back and provide some
details about what you want to do. HTH Otto

 

[Guest]

Thank you very much for the response. I suppose I was thinking that the
simple task of creating a form that would enable a user to tab between
"fields" and enter data as well as select information from drop down lists
would not include vb codes and the like.

I was able to find out how to use "Data"->"Validation" to create the drop
down lists, but it is still not as user friendly, or visually appealing as I
would like.

But I am grateful for any help or hints you can provide.

Thank You,

Marlene

 

[Guest]

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!!!