+ Reply to Thread
Results 1 to 5 of 5

How do you insert a symbol in VBA?

  1. #1
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    How do you insert a symbol in VBA?

    Hello,

    I would like to insert a check mark symbol in my VBA code. I inserted the check mark in my spread-sheet by going to the menu Insert/Symbol/ Symbols Tab Font: Haettenchweiler, Subset: Mathmatical Operator. I am using the square root as a check mark. it is character code 221A and looks like this √. I pasted and copied this symbol from the spread-sheet and tried to put it in my VBA code and it pasted a question mark. Is there a way to assign this character to a string variable like the following:
    Please Login or Register  to view this content.
    I do not have to use that particular symbol, if there is another check-mark that is easier to use!
    Thanks for your help!
    redsab
    Last edited by redsab; 08-30-2013 at 02:54 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: How do you insert a symbol in VBA?

    How about...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: How do you insert a symbol in VBA?

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: How do you insert a symbol in VBA?

    Yes Jeff, that works great! Thanks so much!
    redsab

  5. #5
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: How do you insert a symbol in VBA?

    protonLeah,

    That is a very nice looking check. It actually looks like a check as opposed to my square-root sign (lol). Thank you for your help!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert a symbol
    By Lloydee in forum Excel General
    Replies: 3
    Last Post: 08-12-2007, 08:34 AM
  2. [SOLVED] RE: Insert symbol
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2006, 09:55 AM
  3. [SOLVED] Insert symbol
    By Frank E in forum Excel General
    Replies: 3
    Last Post: 06-23-2006, 09:50 AM
  4. [SOLVED] insert symbol
    By Santosh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-19-2005, 01:07 AM
  5. Replies: 2
    Last Post: 05-02-2005, 08:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1