Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2019, 03:57 AM
gloub gloub is offline Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Windows 7 64bit Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Office 2003
Novice
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on
 
Join Date: Feb 2018
Location: Paris, France
Posts: 29
gloub is on a distinguished road
Default Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on

Hi!



In the Office 365 version for Mac, I couln't find a way to change the case by toggling between 1st letter in upper case / all in upper case / all in lower case / all in lower case (as on PC by pressing Shift + F3).

On my Mac, the F3 key only reverses the case, but the result is not satisfactory: switching from "Hello Everybody" to "hELLO eVERYBODY" is useless.

So I've tryied to simulate the behavior of Word for PC with a macro, but my knowledge of VBA is too limited.
Could someone help me?
Thank you!!!!

PS: as I'm greedy, I even imagine making some improvements compared to the PC version, toggling: wdToggleCase / wdTitleSentence / wdTitleWord / wdUpperCase / wdLowerCase... and even returning to how the text looked like before executing the macro – that would be a Deluxe version.
Reply With Quote
  #2  
Old 01-20-2019, 02:50 PM
macropod's Avatar
macropod macropod is offline Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Windows 7 64bit Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,491
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Shift-F3 is supposed to do the same thing on a Mac, without the need for a macro. See: https://support.office.com/en-us/art...1-a6e3e1284b25
If that's not happening for you. you may have a faulty Office installation, or some other process may have taken over the Shift-F3 shortcut. You should check out what that shortcut is assigned to and, if incorrect or unassigned, correct it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-30-2019, 12:40 PM
gloub gloub is offline Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Windows 7 64bit Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Office 2003
Novice
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on
 
Join Date: Feb 2018
Location: Paris, France
Posts: 29
gloub is on a distinguished road
Default

Sorry for this late answer.

You were right : I've made a few changes (randomly I must say, as nothing seemed relevant), and Shift + F3 works again !

Otherwise I've discovered that wdNextCase could have done the job.

Thanks.


PS : I don't know how to declare this thread is solved...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Only lower case in column without formula 14spar15 Excel Programming 5 08-26-2018 09:48 PM
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Issue with Accented Letter Replacement (Upper/Lower Case) onlywonderboy Word VBA 1 12-21-2017 08:57 PM
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on Change lower case to caps whole document lmb100 Word 4 08-07-2015 06:57 AM
Toggle between upper case, lower case, etc... by one single macro on a Mac, to emulate Shift + F3 on From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM
Upper to lower case jd Excel 1 04-28-2006 07:40 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:19 PM.


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