Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2018, 09:18 PM
macropod's Avatar
macropod macropod is offline Word macro to change ALL CAPS to UPPERCASE Windows 7 64bit Word macro to change ALL CAPS to UPPERCASE Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Why do you need a macro at all to "change all instances of ALL CAPS to uppercase"? All you need do is choose 'UPPERCASE' from the 'Change Case' dropdown...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-30-2018, 06:12 AM
dita dita is offline Word macro to change ALL CAPS to UPPERCASE Windows XP Word macro to change ALL CAPS to UPPERCASE Office 2010 64bit
Advanced Beginner
Word macro to change ALL CAPS to UPPERCASE
 
Join Date: Apr 2018
Posts: 34
dita is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Why do you need a macro at all to "change all instances of ALL CAPS to uppercase"? All you need do is choose 'UPPERCASE' from the 'Change Case' dropdown...
As far as I know there is no way to select the option UPPERCASE in the wildcards. Otherwise, we should change all instances one by one.
Reply With Quote
  #3  
Old 04-30-2018, 02:34 PM
macropod's Avatar
macropod macropod is offline Word macro to change ALL CAPS to UPPERCASE Windows 7 64bit Word macro to change ALL CAPS to UPPERCASE Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dita View Post
As far as I know there is no way to select the option UPPERCASE in the wildcards. Otherwise, we should change all instances one by one.
You're missing the point - you don't need a macro at all (just select the whole document and use the 'Change Case' dropdown's 'UPPERCASE' option) or, if you're wedded to using a macro, anything to do with Find/Replace, hence:
Code:
Sub Demo(): ActiveDocument.Range.Case = wdUpperCase: End Sub
There it is, all in one line and way faster than eduzs' code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word macro to change ALL CAPS to UPPERCASE Need a Macro to Change Every Instance of Small Caps to All Caps and Reduce the Font by 2 Points CrossReach Word VBA 2 11-13-2017 09:21 AM
How to find CAPITALIZED names and change them into small caps dylan.ve Word VBA 5 02-25-2016 03:15 PM
Word macro to change ALL CAPS to UPPERCASE Change lower case to caps whole document lmb100 Word 4 08-07-2015 06:57 AM
Using conditional formatining to change to all caps Shades Excel 3 05-05-2014 06:05 AM
find&replace word in uppercase with word in lowercase andrei Word 3 10-03-2011 05:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft