In VBA print "box" (Windings q)

Posted on 2004-10-30
Last Modified: 2008-03-17
I have a VBA macro that prints a checkoff list. I want it to print a box, which I can get in Word with a Windings letter q. I have the followng in my code:

    Selection.Font.Name = "Windings"
    Selection.TypeText Text:="q"

but it just prints the letter q. If I manually select the q and then select Format|Font|Wingdings, the q gets converted to the box I want.
Question by:cbutton
    LVL 80

    Expert Comment

    Hi cbutton,
    You didn't say which application you were using. In Excel, you can do it like this:

    Sub SquareBox()
    With Selection
        .Font.Name = "Wingdings"
        .Value = "q"
    End With
    End Sub


    LVL 6

    Accepted Solution

    I assume (and tested in Word) this is just a typo problem : replace "Windings" by "Wingdings" (with a "g" between "n" and "d").
    I should work !


    Author Comment

    Sorry I didn't name the application. It is MS Word.

    I'll try the two suggestions when I get back this afternoon.l

    Author Comment

    david_barker: I don't know how many times I looked at that "windings" and saw "wingdings." I'm sure glad you spotted it! Thanks.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now