Multi Line Bookmark

streng · #1 07-09-2009, 10: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, 04:39 PM

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

Bird_FAT · #3 07-13-2009, 11: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, 11: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
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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