Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2009, 06:38 AM
streng streng is offline Multi Line Bookmark Windows XP Multi Line Bookmark Office 2007
Novice
Multi Line Bookmark
 
Join Date: Sep 2008
Posts: 11
streng is on a distinguished road
Default Multi Line Bookmark

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

Reply With Quote
  #2  
Old 07-09-2009, 12:39 PM
streng streng is offline Multi Line Bookmark Windows XP Multi Line Bookmark Office 2007
Novice
Multi Line Bookmark
 
Join Date: Sep 2008
Posts: 11
streng is on a distinguished road
Default

Is there a way to do this or am i needing six different bookmarks ?
Reply With Quote
  #3  
Old 07-13-2009, 07:35 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Multi Line Bookmark Multi Line Bookmark Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 07-13-2009, 07:54 AM
streng streng is offline Multi Line Bookmark Windows XP Multi Line Bookmark Office 2007
Novice
Multi Line Bookmark
 
Join Date: Sep 2008
Posts: 11
streng is on a distinguished road
Default

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



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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft