Use F2 key for editing

[Paul Cornet]

I am transitioning from Excel PC to excel 2004 for Mac. One thing that I
find particularly annoying is that to edit in cell, I have to type ctrl-u
rather than the F2 key which I am used to.

I have found the 'customize keyboard' option under tools but that only
allows me to assign menu functions to keys, and edit in cell (or ctrl-u,
does not appear to be a menu function).

Would anyone have a suggestion to do that?


Thanks

Paul
(e-mail address removed)

 

[JE McGimpsey]

I am transitioning from Excel PC to excel 2004 for Mac. One thing that I
find particularly annoying is that to edit in cell, I have to type ctrl-u
rather than the F2 key which I am used to.

I hear you - I hated it when MS changed the shortcut to F2 (which is
traditionally the Cut command in Mac applications) when they ported XL
from Mac to Windows, too...

I have found the 'customize keyboard' option under tools but that only
allows me to assign menu functions to keys, and edit in cell (or ctrl-u,
does not appear to be a menu function).

Would anyone have a suggestion to do that?

Take a look at

http://www.mcgimpsey.com/macoffice/excel/f2.html

 

[Jim Naeve]

Great tip however, I followed the instructions as stated on their website
but encountered an error with the PMW on the second line in this script:

Public Sub F2Edit()
** CommandBars.FindControl(Id:=6034).Execute **
Application.OnKey "{F2}", "F2Edit"
End Sub

Has anyone come up with the same problem and if so, what is the fix?

BTW, I'm running Microsoft Office 2004

Thanks!
Jim

 

[Jim Naeve]

One more element - the actual error message says: "Runtime Error '91':" -
"Object Variable or With Block Variable Not Set"

Sorry but I'm not a real good Office VBA guy - I can knock out the formulas
but when it comes to coding, I basically suck at it.

Thanks again for the assistance.
Jim

 

[JE McGimpsey]

Great tip however, I followed the instructions as stated on their website
but encountered an error with the PMW on the second line in this script:

Public Sub F2Edit()
** CommandBars.FindControl(Id:=6034).Execute **
Application.OnKey "{F2}", "F2Edit"
End Sub

Has anyone come up with the same problem and if so, what is the fix?

Yeah, I had the fix long ago, but I couldn't post it until Office04 was
released. I then promptly forgot (and forgot to put a tickler in
Entourage).

Several Control ID's were changed in XL04, ostensibly to match WinXL.

The code is fixed now:

http://www.mcgimpsey.com/macoffice/excel/f2.html

 

[Jim Naeve]

Excellent - thank you! It's too bad they can't just keep the keystrokes the
same between Win & Mac. After a long day of spreadsheets on a Win machine
at the office, coming home to pound away on my personal data on the Mac with
a different set of key strokes is confusing.

Thanks again! VERY HELPFUL!!

Cheers,
Jim

 

[JE McGimpsey]

Excellent - thank you! It's too bad they can't just keep the keystrokes the
same between Win & Mac.

I certainly agree with you. I was royally p*ssed when MS ignored the
long-established standard keystrokes when they ported XL from Mac to
Windows.

F2 should never have been used for Edit Cell...

 

[paul]

Jim, thanks the code now works for me to, but it actually does not
really perform the equivalent of a 'ctrl-u', which edits in cell and
puts difference color grids on the formula inputs, it seems to open
the formula bar. Is there a way to edit your code so that it performs
the exact same function as a ctrl-u?

thanks.

paul

 

[JE McGimpsey]

Is there a way to edit your code so that it performs
the exact same function as a ctrl-u?

AFAIK, no.