Results 1 to 3 of 3

Thread: How do I add a Unicode character to Excel cell using VBA?

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    14

    How do I add a Unicode character to Excel cell using VBA?

    Hi.

    I'm looking at the charmap and have selected a character within the following fonts: Lucida Sans Unicode

    At bottom of the charmap the following is displayed:

    U+2588: Full block

    (it is a black square shaped character)

    What kind of VBA code do I have to use to get this character in an excel cell?

  2. #2
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: How do I add a Unicode character to Excel cell using VBA?

    This ought to do it:

    VB Code:
    1. With Range("E3")
    2.         .Value = ChrW(9608) '2588h = 9608d
    3.         .Font.Name = "Lucida Sans Unicode"
    4.     End With
    Last edited by VBAhack; Jun 13th, 2006 at 03:53 PM.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    14

    Re: How do I add a Unicode character to Excel cell using VBA?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width