Results 1 to 5 of 5

Macro to deduct entered value

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Macro to deduct entered value

    Hi,
    Recently I made an Excel spreadsheet (Excel 2003) and used macros to add a specific amount to each cell when clicked. While setting up the spreadsheet, I had encountered another macro method that I am trying to do now.

    The macro was simply, when a cell was selected and the macro button click, a small window would pop up (with user written description) and you input the amount you wanted to deduct, and the macro would do it. Now I can't find the website I learnt that from and I'm in real need of it. Would anyone be able supply the macro code for this function, or direct me to the right place?

    Example, I click on a cell and then click the macro. A pop up window would appear, and the window has instructions that I created in the script editor ("Enter the amount you would like to deduct") and I would input the amount into the small box ("5"). The macro would then deduct 5 from the cell.

    Thanks in advance.
    Last edited by The Last Day Dawns; 06-20-2010 at 09:39 AM.

Thread Information

Users Browsing this Thread

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

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