UserForm

[tariqnaz2005]

Hi all,

I m back after my vecation..before vecation i was doing an excel acconut General Ledger with the help of you guys..

You always helped me out for all my problems..

Now i m in last stage of my account ledger, I m totally new in userform in VB and Need A beautifull USER FORM with cute layout and formating of my attached sheet..

Columns hidden i dont use because there i wil put formulas..

Now I need a Form so with combo box so that i can enter my Data and pls also give me some facility if i put my PV Number and can get all rows and further more i can copy this all data and past it for new entry ..so that i can save my time to make again and again same repearted entries every month..

Thanks in advance..

User Form.xlsx

[royUK]

I've posted numerous userform examples. You need to adapt one.

[royUK]

Excel also has a ready made form

Click a cell in the range or table to which you want to add the form.
To add the Form button to the Quick Access Toolbar, do the following:
Click the arrow next to the Quick Access Toolbar, and then click More Commands.
In the Choose commands from box, click All Commands, and then select the Form button in the list.
Click Add, and then click OK.
On the Quick Access Toolbar, click Form .

[tariqnaz2005]

Hello RoyUK, nice to see you, how r u?

But i want a self made form cuz with more facility same as accounting software..i want my this seet more beautifull and easy to enter data..

pls give me some costly time and design for me or link your old exapmples cuz i did not get any one.

thanks

[tariqnaz2005]

Is any one working on it plsease?

[royUK]

make an attempt yourself then post for specific help. We are here to help, not offer free solutions