typing a □ in MS Word

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
As noted by Jay Freedman in the thread above, the unicode character (27E1) you provided displays a diamond in cambria font. You must find a character that is a square.

For example:
Selection.TypeText Text:=ChrW(&H25A1)
 
Upvote 0
25A1 is one - did you try it? From the keyboard you type Alt 09633. Search the Insert Symbol dialog for characters - it will also show the Hex value at the bottom.
 
Last edited:
Upvote 0
I don't know what a hex value is. I found the symbol on the insert dialogue box but i can't find out how to read what character it is.
 
Upvote 0
See the image link below. The selected symbol is a square, and its hex value is shown at the bottom of the symbol dialog box (In Word this is under Insert | Symbol):

http://www.northernocean.net/etc/mrexcel/20120108_capture.png

In your macro you would use the hex value by adding a &H to it with the unicode character function ChrW():
Selection.TypeText Text:=ChrW(&H25A1)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,225,610
Messages
6,185,986
Members
453,333
Latest member
BioCoder84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top