Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
In some spreadsheets I need to enter a phrase in many cells. Is it possible
to pre-program the function keys with a phrase so it may be inserted into a spreadsheet at the push of that key. If so, how can it be done? Thanks. Bill Ridgeway |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
How about a nice custom menu toolbar
-- Don Guillett Microsoft MVP Excel SalesAid Software "Bill Ridgeway" wrote in message ... In some spreadsheets I need to enter a phrase in many cells. Is it possible to pre-program the function keys with a phrase so it may be inserted into a spreadsheet at the push of that key. If so, how can it be done? Thanks. Bill Ridgeway |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
"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. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
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. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
On May 15, 11:33*am, "Bill Ridgeway" wrote:
In some spreadsheets I need to enter a phrase in many cells. *Is it possible to pre-program the function keys with a phrase so it may be inserted into a spreadsheet at the push of that key. *If so, how can it be done? Thanks. Bill Ridgeway Does it have to be the function keys? Why not record a regular macro and assign it to a keystroke? Or even put it up on the QAT? Ed |
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
"Ed from AZ" wrote in message
... On May 15, 11:33 am, "Bill Ridgeway" wrote: In some spreadsheets I need to enter a phrase in many cells. Is it possible to pre-program the function keys with a phrase so it may be inserted into a spreadsheet at the push of that key. If so, how can it be done? Thanks. Bill Ridgeway Does it have to be the function keys? Why not record a regular macro and assign it to a keystroke? Or even put it up on the QAT? Ed Thanks Ed. No. It doesn't have to be function keys. Just thought they are the least used keys and wouldn't cause a conflict if used for my purpose. What's the QAT? Bill Ridgeway |
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
What's the QAT?
In XL 2007, it's the Quick Access Toolbar. When MS introduced the ribbon, they eliminated all the standard toolbars that we could customize with macros and frequently used commands. Now the best you can do is add it to the QAT. Ed |
#8
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
Pre-programming keys
Look at the free or paid versions of ShortKeys at http://www.shortkeys.com/
Useable in almost any program. Eric "Bill Ridgeway" wrote in message ... In some spreadsheets I need to enter a phrase in many cells. Is it possible to pre-program the function keys with a phrase so it may be inserted into a spreadsheet at the push of that key. If so, how can it be done? Thanks. Bill Ridgeway |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba programming | Excel Discussion (Misc queries) | |||
CD Programming | Excel Discussion (Misc queries) | |||
Programming function keys in Excel | Excel Discussion (Misc queries) | |||
programming | Excel Discussion (Misc queries) | |||
Programming help | Excel Discussion (Misc queries) |