View Single Post
 
Old 02-01-2019, 03:04 AM
mroatman mroatman is offline Mac OS X Office 2019
Novice
 
Join Date: Jan 2019
Location: Tallinn, Estonia
Posts: 9
mroatman is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
The bullet is probably the letter m in a different font
I discovered the problem. Your helpful code:

? Asc(Selection.Text)

actually doesn't appear to work for these bullets. I suppose this is because automated bullet lists are not treated as standard text. Instead, that formula was retrieving the font code for the next immediate letter -- in this case, M.

I did some digging and discovered the bullet character I'm using is Symbol character 183 (Unicode character F0B7). But I do not know how to plug this information into the

.Text =

field. I looked up a Unicode translation here, but it is not intelligible to me.

Do you know how to write Symbol 183 / Unicode F0B7 in a way that VBA understands?

Thanks again for your ongoing help. I really appreciate it.
Reply With Quote