Thread: Update Bookmarks from a Userform
View Single Post
 
Old 05-02-2014, 02:44 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I don't see that the code would 'create' errors. Of course, if you have an empty or invalid cboName.Value, that's what will be output at the Bookmark "Name". For the same reason, because the Select Case statement only tests valid values, you could end up with an invalid output for the Bookmark "ID". That could be prevented by adding:
Case Else: StrOut = ""

PS: Please don't automatically quote the entire posts being replied to. If there's something in a reply you need to reference, quote just that portion.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote