Macro to Wrap Selected Text with Brackets

S

Stefan Blom

Try the following macro:

Sub AddBrackets()
Selection.InsertBefore "["
Selection.InsertAfter "]"
End Sub
 
R

RYA

Hi,

Is there a way to wrap pre-selected text with brackets using VBA? To
explain, the user types text (can be numbers, dates, one or more words),
selects the text to be wrapped with brackets and kicks off a macro to insert
open bracket at the beginning ([) and a closing bracket (]) at the end of
the selection.

Thanks in advance.
 
Top