Quick Button to Automatically Enter Text?

[cookeetree]

G'day Excel Gods,

Is there a way of setting up a quick button (ie: CTRL+, ALT+, etc) to automatically enter regularly-used words or text?

I regularly have to enter L.C.L. or R.C.L. into worksheets and it's a slow task, even though I'm able to touch type.

 

[PeteWright]

Yep, doable.

Follow the steps from the screenshots to get it done on your computer.

1. Enable Developer Tools

right-click on any item of the ribbon and click "Customize the Ribbon..."

enable the Developer Ribbon

2. Record a Macro for each value/text you want to insert

on the Developer Tab click on "Record Macro"

enter the values like on the screenshot for "L.C.L." and press OK

now type "L.C.L." into any cell ant press Enter

stop the Macro Recorder

record another Macro for "R.C.L." with below values

type "R.C.L." into any cell and press Enter

Again, close the Macro Recorder

3. Finalize the Macros
Click on "Macros" on the Developer Tab

Now edit the macros you created. They are both stored in one workbook. Select any Macro and click "Edit"

Now this should open the VBA Editor and a window like on the screenshot will open (layout and colors may vary)

Now edit the VBA code of both macros so it is not hard-coded to insert your desired text into cell "A1" only
Clean up the code like in the example below

Save the workbook

4. Test the Shortcuts

Now you should be able to insert your desired text into any cell by pressing [Ctrl]+[L] or [Ctrl]+[R]


Please let me know if anything doesn't work or if you need further assistance.

 

[cookeetree]

Yep, doable.

Follow the steps from the screenshots to get it done on your computer.
....
Please let me know if anything doesn't work or if you need further assistance.

Thank you so much for your help, Pete. This works exactly as you expected it.

One smaaaaall thing I forgot to mention was that I need to enter the L.C.L. / R.C.L. into a cell that I'm already typing in. (ie: I need to enter something like "3.4m L.C.L.")

The code you gave me doesn't allow me to use the CTRL command whilst I'm actively entering data in to the cell.

Any chance you've got an alternative fix up your sleeve?

Cheers, Jason.

 

[PeteWright]

I'm afraid that can't be done with plain Excel without some VBA coding.

But I found a very promising tool called ClipboardMaster.
ClipboardMaster - Features Overview

Maybe you could give it a try, it has AutoComplete features too.