

If you are familiar with the shortcut keys, the below shortcut keys also can help you, please do as this:ġ. And then, click Insert button, the selected bullet will be inserted between the words, see screenshot: In the Symbol dialog box, choose the bullet symbol that you want to insert, see screenshot:ģ. Put the cursor at the place where you want to insert the bullet, and then click Insert > Symbol > More Symbol, see screenshot:Ģ. The normal Symbol feature in Word can help you to insert the bullet between words, please do as this:ġ. Insert bullet between words in Word document by using shortcut keys Insert bullet between words in Word document by inserting symbol feature May be it is easy for us to insert a list of bullets before the text in a Word document, but, if you need to insert the bullet between words in a line, how could you do? ParagraphFormat.How to insert bullet between words in a Word document? ListTemplate:=.ListGalleries(wdOutlineNumberGallery).ListTemplates(1), _

ListGalleries(wdOutlineNumberGallery).ListTemplates(1).Name = ""

ParagraphFormat.Alignment = wdAlignParagraphLeft ListTemplate:=.ListGalleries(wdBulletGallery).ListTemplates(1), _Ĭontinuepreviouslist:=False, applyto:=wdListApplyToWholeList, defaultlistbehavior:=wdWord9ListBehavior ListGalleries(wdBulletGallery).ListTemplates(1).Name = "" TextPosition = objWord.CentimetersToPoints(1.27) NumberPosition = objWord.CentimetersToPoints(0.63) Set temp3 = objWord.ListGalleries(wdNumberGallery).ListTemplates(1) ObjSelection.TypeText ("Here is more text") ObjSelection.TypeText ("This is my text in Word Document using Excel") Set objWord = CreateObject("Word.Application") Note that this requires adding a reference to Microsoft Word 15.0 Object Library Sub Generate() I had some trouble adding bullets, so here is the code that worked for me. Paragraphs(2). ListTemplate:= _Įxample from Excel VBA for creating numbered list in Word ListGalleries(wdNumberGallery).ListTemplates(1), ContinuePreviousList:= _įalse, ApplyTo:=wdListApplyToWholeList, DefaultListBehavior:= _ ' why does this have to be done after creating text?

' Yields execution so that the operating system can process other events. Set oWordApp = CreateObject("Word.Application") Set oWordApp = GetObject(, "Word.Application") '~~> Establish an Word application object Can this be done in a single pass like VBA allows us to do with bold or italics?ĭim oWordApp As Object, oWordDoc As Object In order to do certain formatting (bullets, numbering, putting text in tables etc.) it appears necessary to make a second pass and apply formatting after text is created. In the example below, I write a Word paragraph 6 times. I have been playing with VBA code that permits automatic creation of word documents.
