I'm completely new to macros in MS Word, but not entirely new to programming.



I'm looking to select all of the words in my document that begin with a "7" and end with a "pm". They have varying stuff in between such as "7:47pm" and so on.

How would I go about making such a macro in VBA?

Once selected, I would like to change the font size down to 7.

I would imagine this would be super simple macro for those experienced, but I really have no idea where to start.

Any suggestions are appreciated.

Thanks!

Hi gcom,

If you're wanting to change the whole string to 7pt, use a wildcard Find/Replace, where:
Find = 7:[0-9]{2}pm
Replace = ^&
and the replacement font option is set to 7pt.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you so much for helping me with that!

So, how exactly does that work? I understand the "7:" and "pm" obviously, but what is with the "[0-9] and the "{2}"?

The "^&" just replaces with the same content in the find box, right?

Thanks!

The [0-9] tells Word to find any number from 0-9; the {2} specifies that it must be a 2-digit number.

You're right about the ^&.

Check out Word's Help file for more details on using wildcards.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

macropod
What is the function of ^? while using it in find dialog (I mean CTRL+F)?

The '^?' combination means 'any character' but is not valid for a wildcard Find. For other control characters you can use in the Find/Replace expression, see: https://support.office.microsoft.com...rs=en-US&ad=US

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]