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
07-03-2014, 02:12 PM
Similar Threads
Can you create a button that indicates the status of markup display?
Windows 7 32bit 
Office 2010 (Version 14.0)
Hybrid Mode