Macro to reverse a test string

		Microsoft Office Forums > Microsoft Word > Word VBA
Macro to reverse a test string

FAQ

Thread Tools

Display Modes

01-16-2014, 09:09 AM

Jennifer Murphy Jennifer Murphy is offline

Windows XP Macro to reverse a test string

Office 2007

Competent Performer

Join Date: Aug 2011

Location: Silicon Valley

Posts: 234

Jennifer Murphy is on a distinguished road

Macro to reverse a test string

I wrote this little macro to reverse a text string. I have 2 questions:

How can get the macro to leave the selection selected?
Does anyone have any comments on the code? Is there a better way?

Code:

Sub MyRevText()
Dim oRange As Range
Dim sString As String

Set oRange = Selection.Range
sString = oRange.Text
sString = StrReverse(sString)
oRange.Text = sString

End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Macro to create new word doc and save the file using String found in the document	VBNation	Word VBA	2	02-08-2013 07:14 AM
Call Macro from Input Box String	Paulsh	Word VBA	1	11-01-2011 03:15 AM
Macro VBA "Save as" with bookmarks in file name string	Dom37	Word VBA	2	10-31-2011 03:28 AM
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 AM.