Enable a user to double-click text in a document to change its value

  • Thread starter Thread starter steven malosky
  • Start date Start date
S

steven malosky

i got a solution off mvp for changing "Y" to"N" to "?" within a document by
double clicking on the field (using macrobutton field). BUT, when i tried
to substitute a line of text for the single letters (Y or N or ?) it won't
work - anybody know why?

(below is the macro code)
Sub SymbolCarousel()
'
' SymbolCarousel Macro
' Macro recorded 2/29/2004 by malosky
'


Select Case Selection.Fields(1).Code.Characters(29)
Case "Y"
Selection.Fields(1).Code.Characters(29) = "N"
Case "N"
Selection.Fields(1).Code.Characters(29) = "?"
Case "?"
Selection.Fields(1).Code.Characters(29) = "Y"
Case Else
End Select

End Sub
 
Back
Top