Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><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></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>