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
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