ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using forms In excel (https://www.excelbanter.com/excel-discussion-misc-queries/171068-using-forms-excel.html)

pillai

Using forms In excel
 
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

Using forms In excel
 
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.


pillai

Using forms In excel
 

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.



All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com