This is a method that works more reliably than using the Workshee
Change event. This will allow you to enter a value in a cell, the
double click the cell for the recalculation.


-in the VB editor select the sheet you are using for costing
-from the view menu, select 'Code'
-select 'worksheet' from the dropdown menu, and in the right drop dow
menu
select the 'before double click' event.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cance
As
Boolean)

' This is the code that will allow you to double click on the cell fo
a recalculation
' multiplying by 2 and adding 0.99

-*ActiveCell.Value = ActiveCell.Value * 2 + 0.99*-


End Su

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=27366