Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How do I insert symbols using VBA?

Can you insert Unicode characters using VBA in EXCEL 2002? If you try to
record a macro with the menu command INSERT/SYMBOL..., you don't get much of
a clue.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How do I insert symbols using VBA?

With ActiveCell
.Value = chrw(1500)
.Font.Name = "Arial Unicode MS"
End with

--
Regards,
Tom Ogilvy

"VBtwisted" wrote in message
...
Can you insert Unicode characters using VBA in EXCEL 2002? If you try to
record a macro with the menu command INSERT/SYMBOL..., you don't get much

of
a clue.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How do I insert symbols using VBA?

Thank you, Tom

"Tom Ogilvy" wrote:

With ActiveCell
.Value = chrw(1500)
.Font.Name = "Arial Unicode MS"
End with

--
Regards,
Tom Ogilvy

"VBtwisted" wrote in message
...
Can you insert Unicode characters using VBA in EXCEL 2002? If you try to
record a macro with the menu command INSERT/SYMBOL..., you don't get much

of
a clue.




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
Where can I find symbols for telephone, fax, and email to insert . Bomar Excel Discussion (Misc queries) 3 April 27th 23 11:52 AM
How to insert maths symbols into an excell function? Maths symbols on excell Excel Worksheet Functions 1 May 16th 10 08:53 PM
How to insert symbols if you don't have a symbol menu? Bine_NZ Excel Discussion (Misc queries) 1 September 17th 09 04:19 AM
install symbols on the insert menu? Bewildered Jim Setting up and Configuration of Excel 1 August 11th 05 03:20 PM
How do I insert currency symbols in Excel? The Angry Ant Excel Discussion (Misc queries) 1 June 27th 05 09:15 PM


All times are GMT +1. The time now is 10:00 AM.

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

About Us

"It's about Microsoft Excel"