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.)

11 comments:

  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).
    Thanks

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

    ReplyDelete
  3. please send me sample file Vipul.srivastav12@gmail.com

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

    ReplyDelete
    Replies
    1. This link is valid : http://adf.ly/1QtpZr

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

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

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

    So Please Can You Provide me. Please.

    ReplyDelete