View Single Post
 
Old 09-18-2014, 12:35 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

It's all pretty basic, really. Assuming companyname is either the name of a textbox on your userform or a string variable's name (you don't say what it is), your code should be:
Code:
Private Sub CommandButton1_Click()
  Call UpdateBookmark("companyname", companyname)
End Sub
Then all you need do is add the UpdateBookmark sub from post #2 to your code module.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote