Symbols on VBA UserForm (HTML symbols)

Topic

New Reply

There are two symbols, ballot box and ballot box with x, which we want to offer as symbols to be added to a Word document. The symbols are ☐ and ☒. How do I add those to a document using Selection.TypeText? Also, will I be able to use the same sort of thing to add them to a list box in a VBA form?Thanks.

Reply | Quote

Replies

Using the Wingdings font the character values are 168 & 120 respectively so use Chr(168), etc.:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thank you. And is it possible to put this symbol into a list box in VBA?

Reply | Quote

The following should work.

.AddItem = Chr(120) & ” ” & {text or variable here}

The only problem I see here is that the font in the ListBox may not have those characters at those positions.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

That’s why I originally thought that Hex would be more reliable. In my original message, I used the Hex code, but I see it got “translated” to the actual symbols.

Reply | Quote

I don’t think you can change the font inside a userform’s listbox control. Can you use the checkbox control instead?

Reply | Quote

I could put this directly on the Ribbon, but that wouldn’t be consistent with our other symbols. I have a non-modal user form which the user can position wherever it’s handy, like a floating palette, and it remains open after inserting accented letters, typographic symbols, etc.

Reply | Quote

It is possible to change the font of a list or combo box, but — of course — it changes the font for the entire control. The only two Wingding items are these 2 boxes, so the font setting doesn’t help me.

Reply | Quote

In Word 2010, I can use ChrW(&Hnnnn) to insert Unicode symbols into a ListBox. See attached. (I got the numbers by scrolling through the Arial Unicode MS character set in the Insert>Symbol dialog.)

Reply | Quote

Thank you! I stupidly used AscW instead of ChrW.

Reply | Quote