recalculation problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi Mike
AFAIK you can't do that. Maybe you could explain what you're trying to
achieve - there may be other solutions
 
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

Mike said:
i need to have one cell recalculate, not when i press f9, but when i
Click to expand...
press, maybe alt+ctrl+1, can i do this? and how.
 
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
 
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
 
Back
Top