Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Special keystrokes in a Macro
When ALT + 0176 is pressed you get the degree symbol. Likewise you get the
sigma character when you press ALT + 997. I would like to incorporate these type of keystrokes into a macro. Is it possible, and if so, how? Thank you in advance for your time and effort. Eric Pearce |
#2
|
|||
|
|||
Hello Eric
Look for Chr() function in VBA help. HTH Cordially Pascal "Eric" a écrit dans le message de news: ... When ALT + 0176 is pressed you get the degree symbol. Likewise you get the sigma character when you press ALT + 997. I would like to incorporate these type of keystrokes into a macro. Is it possible, and if so, how? Thank you in advance for your time and effort. Eric Pearce |
#3
|
|||
|
|||
That works for ASCII characters, but I need to access unicode characters as
obtained by use the keystrokes like ALT+0176 = 'degree symbol', and ALT+997 = 'sigma', etc... Chr() errors at anything above 255. Is there another way? "papou" wrote in message ... Hello Eric Look for Chr() function in VBA help. HTH Cordially Pascal "Eric" a écrit dans le message de news: ... When ALT + 0176 is pressed you get the degree symbol. Likewise you get the sigma character when you press ALT + 997. I would like to incorporate these type of keystrokes into a macro. Is it possible, and if so, how? Thank you in advance for your time and effort. Eric Pearce |
#4
|
|||
|
|||
Eric
Example code using Chr Sub sq_Meters() Selection.NumberFormat = "0"" m" & Chr(178) & """" '0179 for cubic meters End Sub Gord Dibben Excel MVP On Tue, 17 May 2005 08:39:31 -0600, "Eric" wrote: When ALT + 0176 is pressed you get the degree symbol. Likewise you get the sigma character when you press ALT + 997. I would like to incorporate these type of keystrokes into a macro. Is it possible, and if so, how? Thank you in advance for your time and effort. Eric Pearce |
#5
|
|||
|
|||
Apparently I am not explaining myself very well. If I were to press and
hold the ALT key and while holding down the ALT key were to press the number sequence 997 then release the ALT key the greek symbol sigma will apear in the current font. However, the Chr() function doesn't recognize anything above 255. Therefore, I can't access any of the greek symbols which reside in the numbers above 255. I really do understand the Chr() function and it will not work for what I am trying to do. I really do appreciate the suggestions to date, but they don't work. Is there anyone out there that can help? Thanks in again, and in advance. Eric "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Eric Example code using Chr Sub sq_Meters() Selection.NumberFormat = "0"" m" & Chr(178) & """" '0179 for cubic meters End Sub Gord Dibben Excel MVP On Tue, 17 May 2005 08:39:31 -0600, "Eric" wrote: When ALT + 0176 is pressed you get the degree symbol. Likewise you get the sigma character when you press ALT + 997. I would like to incorporate these type of keystrokes into a macro. Is it possible, and if so, how? Thank you in advance for your time and effort. Eric Pearce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Macro ignores Arrow Keystrokes | Excel Discussion (Misc queries) | |||
How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) | |||
Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de. | Excel Worksheet Functions | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Paste Special in a macro | Excel Worksheet Functions |