Macro to deduct entered value

[The Last Day Dawns]

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.

[venkat1926]

are you thinking of a macro like this

Please Login or Register  to view this content.

[The Last Day Dawns]

venkat1926, Thank you so much! That it exactly what I was looking for. Thanks for your help.

Edit: Just a problem I've encountered. Is there a way to stop it from Runtime error if I cancel or 'x' the pop-up window? It says Runtime error 13.

[Leith Ross]

Hello The Last Day Dawns,

The VBA InputBox returns an empty string when the user clicks Cancel.

Please Login or Register  to view this content.

[The Last Day Dawns]

Thank you very much, Leith Ross. It works beautifully now. The students will be very happy!