Prev: Possible Conditional Formatting
Next: Macros running with Validation Rules
From: painter50 on 8 Mar 2010 15:26
A1=B1*C1+D1
A2=B2*C2+D2
A3=B3*C3+D3
A4=B4*B4+B4

I would like to be able the have the total in any one of the A cells to add
up only if the cell is click on. In other words, can a cell be turned off or
on as needed?

--
Joe
From: Don Guillett on 8 Mar 2010 19:42
Right click sheet tab>view code>insert this

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
If Target.Column <> 1 Then Exit Sub
'B1*C1+D1
tr = Target.Row
Target.Value = Cells(tr, 2) * _
(Cells(tr, 3) + Cells(tr, 4))
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"painter50" <painter50(a)discussions.microsoft.com> wrote in message
news:35406FBA-A1AD-452C-B786-6D876B5CF93E(a)microsoft.com...
> A1=B1*C1+D1
> A2=B2*C2+D2
> A3=B3*C3+D3
> A4=B4*B4+B4
>
> I would like to be able the have the total in any one of the A cells to
> add
> up only if the cell is click on. In other words, can a cell be turned off
> or
> on as needed?
>
> --
> Joe

 | 
Pages: 1
Prev: Possible Conditional Formatting
Next: Macros running with Validation Rules