recalculation problem

[Guest]

i need to have one cell recalculate, not when i press f9, but when i press, maybe alt+ctrl+1, can i do this? and how.

 

[Frank Kabel]

Hi Mike
AFAIK you can't do that. Maybe you could explain what you're trying to
achieve - there may be other solutions

 

[Niek Otten]

If you really want just one cell to recalc, select that cell, press F2 and
ENTER.

But I agree with Frank; please explain what you're trying to achieve

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

i need to have one cell recalculate, not when i press f9, but when i

press, maybe alt+ctrl+1, can i do this? and how.

 

[Ron de Bruin]

Hi Mike

Don't know why you want this ???

But you can use Onkey
With Calculation to manual to do it

'This example from the Excel help use SHIFT+CTRL+RIGHT ARROW .
Copy the code in the thisworkbook module and save and reopen the workbook

Private Sub Workbook_Activate()
Application.OnKey "+^{RIGHT}", "test"
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "+^{RIGHT}"
End Sub


Sub test()
Worksheets("Sheet1").Range("C3").Calculate
End Sub

 

[Debra Dalgleish]

You can write a macro and assign it to run on a shortcut key, such as
Ctrl+Shift+R:

Sub RecalcCell()
With ActiveCell
.Formula = .Formula
End With
End Sub