Or, much more simply,
Shell "charmap.exe", vbNormalFocus
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Zack Barresse" <firefytrNO@SPAMvbaexpress.com> wrote in message
news:eGWKTfHGGHA.216@TK2MSFTNGP15.phx.gbl...
> To do so programmatically, try something like this ..
>
>
> Option Explicit
>
> Sub ShowCharMap()
>
> 'Define the variable
> Dim WsShell As Object
>
> 'Set the varible
> Set WsShell = CreateObject("WScript.Shell")
>
> 'Run the variable
> WsShell.Run ("charmap")
>
> 'Clean up objects
> Set WsShell = Nothing
>
> End SubHTH
>
> --
> Regards,
> Zack Barresse, aka firefytr, (GT = TFS FF Zack)
> To email, remove the NO SPAM. Please keep correspondence to
> the board, as
> to benefit others.
>
>
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43C7E941.4BAF9625@verizonXSPAM.net...
>> From that other thread:
>>
>> Insert Symbol was added in xl2002.
>>
>> So if you don't run xl2002+, you'll have to find a different
>> way.
>>
>> You can hit flying windows R (or windows start button|Run)
>> type charmap
>> hit enter
>>
>> or even
>> windows start button|Programs|accessories|System tools|charmap
>> if you like to mouse.
>>
>> Chip Pearson has an addin that may help (if you're using xl2k
>> or lower).
>> http://www.cpearson.com/excel/download.htm
>> (look for Symbolizer and make sure you get the correct
>> version)
>>
>> Geoff Woolhouse wrote:
>>>
>>> In Excel, what is CharMap.exe, where do I find it and how do
>>> I get help
>>> using
>>> it? I need to include characters which are normally only
>>> found in MSWord.
>>
>> --
>>
>> Dave Peterson
>
>
Bookmarks