![]() |
#1
|
|||
|
|||
![]() Hi Dear Experts Few letters are different in other fonts So, I've problems in changing to new fonts I use the following code (copied from internet) to solve this. Case specific. Code:
Private Sub Test1() Dim strFindText As String Dim strReplaceText As String Dim nSplitItem As Long Application.ScreenUpdating = False ' Enter items to be replaces and new ones. strFindText = InputBox("Enter items to be found here,seperated by comma: ", "Items to be found") 'b,n,N,O,G,&,+,`,o,A,T,%,[,+,g{ - Find texts strReplaceText = InputBox("Enter new items here, seperated by comma: ", "New items") 'o,b,n,G,g[,U:,g{,+,H,a[,t[,K:,$,G:,* - Replace texts nSplitItem = UBound(Split(strFindText, ",")) ' Find each item and replace it with new one respectively. For nSplitItem = 0 To nSplitItem With Selection .HomeKey Unit:=wdStory With Selection.Find .ClearFormatting .Replacement.ClearFormatting .Text = Split(b, n, G, o, a, T, ",")(nSplitItem) .Replacement.Text = Split(o, b, n, G, H, ",")(nSplitItem) .Format = False .MatchCase = True .MatchWholeWord = False End With Selection.Find.Execute Replace:=wdReplaceAll End With Next nSplitItem Application.ScreenUpdating = True End Sub 1. I wish to remove input box and use permanent text string in place of that. But some are special characters like (, ), [, ], +, *, {, } 2. If the same is restricted to particular font (say 'xxx') and to particular selection 3. also note that few letters are interchanging like b,o,n etc (so it need to be changed to someother letter before final change Thanking you! Jai |
Tags |
find, font, replace all |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
nrsmd | Word | 3 | 06-05-2015 03:20 PM |
![]() |
cheech1981 | Word | 3 | 08-31-2013 11:22 PM |
![]() |
Jack | Word VBA | 2 | 12-12-2012 09:24 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Find & Replace Insert Issue | mipacker | Word | 0 | 02-18-2009 08:59 AM |