Microsoft Office Forums - View Single Post

ksigcajun · 07-10-2014, 06:58 AM

Quote:

Originally Posted by gmaxey

Yes, the text displayed here is the text associated with the option button selected.

I've tried for a week and still cant get the text to clear if a user decides to click the other option button.

I'm trying to come up with Plan B. Can I clear the text in the bookmark?

Here is where Im at.

Code:

Option Explicit
Dim oBM As Bookmark
Dim oRng As Range
Private Sub OptionButton111_Click()
ActiveDocument.Undo
If Me.OptionButton111.Value = True Then
   Set oRng = ActiveDocument.Bookmarks("BM2").Range
   oRng.Text = "Bids should be sent via email to the email addresses listed above. In the alternative, if Bidder does not intend to bid on this Project, please submit your confirmation of NO BID via email to the email address listed above."
   ActiveDocument.Bookmarks.Add "BM2", oRng
   If Me.OptionButton211.Value = False Then
   **Not sure what I can add here to clear the text**   
End If
End If
End Sub
 
Private Sub OptionButton211_Click()
ActiveDocument.Undo
ActiveDocument.Undo
If Me.OptionButton211.Value = True Then
  Set oRng = ActiveDocument.Bookmarks("BM3").Range
   oRng.Text = "All bids must be sealed and received at the address listed above. Any bid received after that time may, at COMPANY'S sole discretion, be returned unopened.  The bid opening will be private. In the alternative, if Bidder does not intend to bid on this Project, please submit your confirmation of NO BID via email to the email addresses listed above."
   ActiveDocument.Bookmarks.Add "BM3", oRng
   If Me.OptionButton211.Value = False Then
**Not sure what I can add here to clear the text**
   End If
    End If
End Sub