Excel and Bullets

[Learning123]

Hi,
I was wondering if it's possible to put bullets in cells like a word document?

Example:
*Subject1
*Subject2
*Subject3


If not, do you know any alternatives? which still use excel?
As alwasy Much big thank you for everyone's help!

 

[DaleWatson123321]

Hi Learning123,

Yes, you can insert bullets. I don't know of any "automatic" method like in Word or PowerPoint, but I created the following routine that will work just as well...

Sub Insert_Bullet()
curcell = ActiveCell.Value
ActiveCell.Value = "l " & curcell
With ActiveCell.Characters(Start:=1, Length:=1).Font
.Name = "Wingdings"
.FontStyle = "Regular"
.Size = 10
End With
End Sub

This of course requires that you have (or obtain) the "Wingdings" font. However, I believe this font is one of the regular Windows fonts.

I hope this helps. Please advise as you how you make out with it.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Guest_imported]

Change your fonts to wingdings and press the letter l. Type and then change the font to whatever you are using after the bullet.

 

[Guest_imported]

Just like this:

• Gail

Hold ALT key and press 0149 then type

 

[Scott02]

Here's another alternative to the wingding. If you want to have the bullet in the same cell as the data, you can hold down the Alt key and using the keypad, type 0149. This will put a small bullet at the beginning of the contents of the cell. This comes from a Corel Draw Character Reference Chart. Hope this helps.

 

[Guest_imported]

Just like I said above.