Sunday, November 1, 2015

Userform With Multiple Pages

Advanced Userform Example - Userform With Multiple Pages

           We made at a template which creates an userform that contains multiple pages.

The multipage control contains two pages. At page 1,the user can fill in personnel informations (name,address,city,phone,birthdate,birthplace etc.)
At page 2, items of combobox (for choosing city)  can be added.

Also we added new menu on userform. Items of this menu :
- New
- Open
- Save
- Save As
- Print Preview
- Print
- Close

Also these controls can be used in this userform :
– Adding new record
– Deleting record
– Updating record
– Label To see total data
– Viewing items of listbox  with spin buttons (down/up)
– Assigning sort numbers for records (when  an item is deleted from  listbox, the sequence numbers are set again.)


  1. You Are Doing Great Job .. Thanks For Making Excel Lovely Application.
    One Question?
    Can We Build A Complete Document System (DMS) Using Excel, Where We Store A Copy of The PDF, JPG etc Files To A Single Record (Row).

  2. can you please tell me how to make it works for excel 11 on mac. Thank you

  3. please send me sample file

  4. cannot open for download. can you make new link for easy to download..thank you for that

    1. This link is valid :

  5. i can't download the file. it shows that you are not authorized. pls help me

  6. i want to learn basics of basics of vba to create advance userform . can you suggest any book or material......

  7. Helo Sir,
    I need Need a Softwear For Data entry & Billing Invoice.
    Purpos For International Courier

    So Please Can You Provide me. Please.

  8. Please send this userform to as while I download msg shows that u r not authorized to visit this page