How to create code that runs upon modification of a cell in Excel.

Hi,

was wondering if anybody would be able to help me with the following VBA codeing issue.

I have a invoice made up in Excel for a Couriers firm as part of an assignment for Uni. I have a column where the user can input the "Charge Code", then the next column over is where the charge code is translated into a price per mile.

Know here is the problem. I have an If statement written so that if for example charge code is 1, the price per mile column will display £0.80. Thing is I want it to work so that when the user hits enter or clicks away the code will automatically write in the cell the correct price per mile so the formula I have will automatically calculate the invoice total with out the user having to boot up a database and looking at a relevant table to find out the price per mile related to that charge code.

Cheers if you can help me.

 

You can write some VBA to execute on worksheet changed events.

http://www.ozgrid.com/VBA/run-macros-change.htm

I'm not sure where you plan on getting the price per mile data from, but VBA will be your best bet.