User Form for Data Entry In Excel

**tariqnaz2005** · 12-09-2009, 05:10 AM

Hello all,

As you know i m new in excell and always bothering you,

I m doing my account as per attached sheet, daily i have to enter a lot of voucher and i m tired to do it in excell..

is some one can help me to creat a form so that i can enter easily and add or delete any column and set it again?

I tried default form in excell but some better way..cuz i have also some drop down..

Thanks in advance..

for user form.xls

**royUK** · 12-09-2009, 05:16 AM

The simplest way is to select any cell within the data & then select Form from the Data menu, a ready made form will open.

Alternatively see the example DatabaseForm here

http://excel-it.com/vba_examples.htm

**tariqnaz2005** · 12-09-2009, 05:53 AM

But I have some dropdown colunmns also..how i will do that..and also my columns are around 20,

Any better way in VB or something esle..

Thanks

**royUK** · 12-09-2009, 05:54 AM

Take a look at the example

**tariqnaz2005** · 12-10-2009, 06:57 AM

Hello RoUK,

Thanks for reply,
I checked an example but i dont knwo VB, i think VB form is better, i have 3-4 column with validation of dropdown so, it wil be appreciated if you design for me a form so that i can data entry..

if yo u need more information i can give u about my file..

Thanks..

**royUK** · 12-10-2009, 07:56 AM

The example has the basic code to do what you want, you can add ComboBoxes.

The forum is here to help you, not provide finished products

**scaffdog845** · 12-10-2009, 09:40 AM

John,

Welcome to the forum. Please take a few minutes to review the forum rules as this post does not comply with rule #2. The forum rules can be found here http://www.excelforum.com/forum-rule...rum-rules.html