Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I'm pretty new to VB programming but learning fast.<o
></o
>
I have built a calculation spreadsheet so far with formulas in the cells and VB functions with a few VLOOKUPs thrown in.<o
></o
>
I then created a macro and button to insert a new row below the last row and copy all the formula's down to that row.<o
></o
>
Within the row you chose a diameter (from a drop down menu-data validation list).<o
></o
>
I want a msg box to pop up after a diameter has been selected and show the user what the end result would be for that diameter, the diameter before and the diameter after. To show the user that a smaller or bigger diameter might be a better choice in the long run. (I don't know if this is possible as there are 7 stages/cells to the calculations, (lookup, IF statements and VB written functions) that I have used to get the end result for the diameter selected.<o
></o
>
Is this too hard as I can’t pin this down to a certain row as it depends how many rows you have inserted and the user may go back up the rows to change the diameter-so it’s not always the last row. <o
></o
>
Would it be easier to target a column or even the next column which has a calculation in the cell and on recalculation of a cell then the macro runs?<o
></o
>
<o
></o
>
Sorry for the big question -I just wanted to give enough background to show my difficulties.<o
></o
>
<o
></o
>
Thank you in advance for any help you can give me.
<o
></o
>




I'm pretty new to VB programming but learning fast.<o


I have built a calculation spreadsheet so far with formulas in the cells and VB functions with a few VLOOKUPs thrown in.<o


I then created a macro and button to insert a new row below the last row and copy all the formula's down to that row.<o


Within the row you chose a diameter (from a drop down menu-data validation list).<o


I want a msg box to pop up after a diameter has been selected and show the user what the end result would be for that diameter, the diameter before and the diameter after. To show the user that a smaller or bigger diameter might be a better choice in the long run. (I don't know if this is possible as there are 7 stages/cells to the calculations, (lookup, IF statements and VB written functions) that I have used to get the end result for the diameter selected.<o


Is this too hard as I can’t pin this down to a certain row as it depends how many rows you have inserted and the user may go back up the rows to change the diameter-so it’s not always the last row. <o


Would it be easier to target a column or even the next column which has a calculation in the cell and on recalculation of a cell then the macro runs?<o


<o


Sorry for the big question -I just wanted to give enough background to show my difficulties.<o


<o


Thank you in advance for any help you can give me.


