Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Martin Hennegriff
 
Posts: n/a
Default assign a symbol to a shortcut key

Does anybody know, how I may assign a symbol to a shortcut key in XL?
I'd like to insert the check mark symbol (Wingding character code 252) to a
key combination. Any suggestions are highly appreciated.

Greetings,


  #2   Report Post  
swatsp0p
 
Posts: n/a
Default

Open the VBA editor (ALT+F11), find your desired workbook in the left pane.
Right click and select InsertModule. A new window opens on the right hand
pane. In this new window, place this code:

Sub checkmark1()
With Selection.Font
.Name = "Marlett"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
ActiveCell.FormulaR1C1 = "a"
End Sub

Close the VBA session (ALT+F4)

In your sheet, press ALT+F8. In the window that opens, find and highlight
the macro named 'checkmark1' and click Options. Assign your desired
keystroke to use to activate this macro (note: it must be a letter).

With the cell pointer in your desired cell, press ALT+(your selection) to
enter the 'checkmark'.

Note that I used the letter "a" in the Marlette font, as I couldn't find the
keystroke for WingDings. You may adjust the code above if you have that
information.

HTH


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign Macro SUE M Excel Discussion (Misc queries) 1 September 22nd 07 09:00 PM
Shortcut menu does not have hyperlink on it Kelli Excel Discussion (Misc queries) 2 February 24th 05 06:59 PM
Assign to macro missing Paul Excel Discussion (Misc queries) 2 January 22nd 05 09:55 AM
Assign Macro to button in Excel doesnt work Any ideas? Mike@Becketts Excel Discussion (Misc queries) 2 December 20th 04 02:47 PM
How to make [toggling] shortcut keys to superscript and subscript, respectively? Mann Lee Excel Discussion (Misc queries) 8 December 13th 04 01:50 PM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"