Below is my code:
My company logo stay at the left of the header and company detail stay at the
right of the header.
Private Sub btnOK_Click()
' Code to run when OK button is clicked
'
' Declare variables for this procedure
Dim ProtectType As Integer, i As Integer
Dim ErrMsg As String
' Check for any empty textbox
If (OptionButton1.Value = False) And (OptionButton2.Value = False) And
(OptionButton3.Value = False) And (OptionButton4.Value = False) And
(OptionButton5.Value = False) Then
MsgBox "Please select a Company Name!", , ""
Exit Sub
End If
' Insert the information into the bookmarks
' Call macro below to update bookmarks without deleting them
If (OptionButton1.Value = True) Then
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
ElseIf (OptionButton2.Value = True) Then
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
ElseIf (OptionButton3.Value = True) Then
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
ElseIf (OptionButton4.Value = True) Then
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
ElseIf (OptionButton5.Value = True) Then
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
Else
UpdateBookmarkProc "CompanyName", "CompanyName"
UpdateBookmarkProc "RegNo", "RegNo"
UpdateBookmarkProc "Address1", "Address1"
UpdateBookmarkProc "Address2", "Address2"
UpdateBookmarkProc "CountryPostalcode", "CountryPostalcode"
UpdateBookmarkProc "TelNo", "TelNo"
UpdateBookmarkProc "FaxNo", "FaxNo"
UpdateBookmarkProc "URL", "URL"
End If
ErrorHandler:
If Err.Number = 5941 Then ' "no such member of collection"
MsgBox "One or more bookmarks are missing from the template", ,
"Error"
End If
Unload Me
End Sub
Private Sub UpdateBookmarkProc(BookmarkToUpdate As String, TextToUse As
String)
Dim BMRange As Range
Set BMRange = ActiveDocument.Bookmarks(BookmarkToUpdate).Range
BMRange.Text = TextToUse
ActiveDocument.Bookmarks.Add BookmarkToUpdate, BMRange
End Sub