Results 1 to 6 of 6

Creating a reset button for a Invoice

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    Tokyo
    MS-Off Ver
    MS Offuce 2019
    Posts
    45

    Creating a reset button for a Invoice

    Hi,

    I would like to create a "RESET" button which would reverse all the cells to back to the original state.

    As you can see in the attached file that in the "Original state", all the quantity starts with the amount of 1.
    All the values in the "PRICE" starts with the value 0, and the "ITEM" is always empty.

    If a customer comes I insert the "Item name" and the "price", and also change the quantity if needed.
    But after I am finished I would like to be able to have the sheet reversed back the "Original state" with a push of a "Command button".

    I guess I would need a macro to accomplish this, but I have never used one before.
    Could somebody help me with this please?

    RESET BUTTON.xlsx
    Last edited by artner0112; 01-21-2012 at 07:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1