Vba code that automatically inserts new sheet after hitting comman button

  • Greetings to all my excel gurus and VBA high masters;


    I would like to create a VBA code that responds to a command button. The code would basically create a brand new sheet identical to the original sheet prior to any alterations. So for example:


    If sheet one is a form that needs to be filled out--which starts off blank--once it has been completed the user can hit the "create new form" button (if he/she needs to complete another form) and a new sheet with a blank form and a "create new form" button will pop up.


    So far I'm hitting walls here and I'm not even sure where to begin.


    You're wisdom and advice would be greatly appreciated.


    Thank you Gurus & VBA masters


    Sincerely,
    Brand_New2VBA

  • Re: Vba code that automatically inserts new sheet after hitting comman button


    See the summary example here


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


    It shows how to use a template worksheet how you describe

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!