Hi
I hope someone can help me.
I have created a order form in excell which is attatched. I have also created a macro that will calculate the price of postage.
What I would like to do is to have a drop down box that in the postage row that says yes or no. If no is selected then the total for post should be 0 however if yes is selected and the total is over £30.00 then £3.50 should be added. If yes is selected and the order is under £30.00 then £1.50 should be added.
I have managed to do this but only by having a button that when pressed runs the macro. Idealy I would like the macro to be running constantly. I tried to do this on a timer but i got error messages.
However I also thought about trying to get it to run when a certain cell is clicked. Is this possible?
Thanks in advance
Edd
Bookmarks