How do I add a form in an Excel sheet?

Question

How can I add an input form in an Excel sheet. I want to insert values into an Excel cell using the form.

Answer 1

You have to activate the form toolbar.
Of course, IIRC, the form must be handled by VBA code.

Answer 2

ALT+F11 starts the VBA editor in Excel. In there you can create UserForms (Insert | UserForm) which you can bind into their own modules or attach to worksheets.

I suggest you look at the Excel help or MSDN for details of what you can do with UserForms. There are also a lot of VBA tutorials on the web for exactly this sort of thing. Google is your friend.

HTH

Answer 3

There is a quick and dirty method of creating simple forms in Excel. No VBA is required.

First, create a table with the basic format that you want.

E.g.

    A    B    C
1   Name Age  Favourite Animal
2   Jane 11   Horse

Select the range, and then select Data | Form. (This is in Excel 2003.)

It will open up a simple form that allows navigation, creation, deletion, and searching.

Answer 4

@Oddthinking,

Cool trick. Never knew it existed. I had to do a little looking, but you can do it in Excel 2007 as well.

1. Click the Office button, select Excel Options, go to the Customize tab
2. Select 'Commands Not in the Ribbon' from the 'Choose commands from' drop down
3. Find 'Form' in the list and click Add, then click OK

At this point, the Forms command will show up on the Quick Access toolbar, next to the Save and Undo/Redo icons.

Answer 5

Respected Sir,

I have made complete accounting software in axcel having ledger of all parties, integerated balances of all ledgers in one sheet called trial balance. same preperation of profit and loss account and palance sheet thr. trial balances figures.but a main problem i am feeling at the time of posting is that, anyhow posting is according to double entry system, but manually entries posting in ledgers one by one. exemple. if a want to book an exp. of stationary exp.

entry post in two ledgers, (Cash account & Stationary exp.) manually. My question is that i want to post entry thr. a form in excell or thr. a Journal voucher in excel to save my time.

Thanks. Muhammad sarfraz. Cell:0300 or 0321 - 7625248 Email. [email protected] [email protected]