Multi Line Bookmark

streng · #1 07-09-2009, 06:38 AM

Is there any way I can move to the next line within a bookmark in vba

The code I have is as follows but I need the Address to be on new lines.

Code:

If ComboBox1.Value <> "Building Control Letter" Then
    Set rngBookmark = .Bookmarks("Address").Range
        .Bookmarks("Address").Delete
        rngBookmark.Text = "Address #1" & "Address #2" & "Address #3" & "Address #4" & "Address #5" & "Address #6"
          .Bookmarks.Add Name:="Address", Range:=rngBookmark
 
End If

streng · #2 07-09-2009, 12:39 PM

Is there a way to do this or am i needing six different bookmarks ?

Bird_FAT · #3 07-13-2009, 07:35 AM

Can you tell me, what exactly is it you are trying to do?

What is being input? How? How do you get the address (typed in, or drop down box?)
What is the intended output? Format?

Can you also add a copy of the document with annotations, please.

streng · #4 07-13-2009, 07:54 AM

Have figured it out. All I needed was Chr(11) to tab to next line

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot delete line	adkr	Office	1	04-07-2010 09:26 PM
Bookmark to another document	spqr	Word	3	06-26-2009 04:51 AM
changing first line indent	hamster	Word	6	04-07-2009 08:33 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM
TOC printing Error Bookmark not Defined	techexpressinc	Word	0	12-14-2008 05:24 PM