Using forms In excel

[pillai]

I could see in excel that forms can be used. I am trying to get some macro or
any other techinique in such a way that i can enter the datas through the
forms.

 

[FSt1]

hi
excel has a built in form.
on the menu bar....
data>form...
try that and see if you works for you. no macros required. if it doesn't
suit your purposes, post back.

Regards
FSt1

 

[pillai]

Loading forms.
What i am trying to do with macro is that when i am pressing a button it
should lead to the form and from there i need to enter the data base. How to
assign a macro to a button and how to record the macro in such a way that the
form closes only on pressing close button on the form.
thanks
Pillai