ExcelBanter - View Single Post - Pre-programming keys

Don Guillett

Didn't m$ withdraw that version?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Harlan Grove" wrote in message
...
"Don Guillett" wrote...
How about a nice custom menu toolbar
...

Not so simple in Excel 2007.

To answer the OP's question, it can be done for entire cell entries
from READY mode, but not in ENTER, POINT or EDIT modes. It involves
convoluted macros like

Sub foobar() 'set keystroke macros
Application.OnKey "+^{F1}", "foobar1"
Application.OnKey "+^{F2}", "foobar2"
End Sub

Sub unfoobar() 'clear keystroke macros
Application.OnKey "+^{F1}"
Application.OnKey "+^{F2}"
End Sub

Private Sub foobar1() 'one macro
ActiveCell.Value2 = "foo"
End Sub

Private Sub foobar2() 'another macro
ActiveCell.Value2 = "bar"
End Sub

Much. much, much better to use a general macro utility like AutoIt to
do this.