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.

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

Regards
FSt1

"pillai" wrote:

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.

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

"FSt1" wrote:

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

Regards
FSt1

"pillai" wrote:

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.