Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-11-2023, 03:59 AM
ChrisGreaves ChrisGreaves is offline VBA detecting style used Windows 10 VBA detecting style used Office 97-2003
Novice
 
Join Date: Nov 2022
Location: Bonavista, Newfoundland
Posts: 22
ChrisGreaves is on a distinguished road
Default

Quote:
Originally Posted by NicoleJones View Post
Is it possible to write VBA code to detect the style currently used?
Hi Nicole. I have a slew of utility procedures for manipulating styles. The attached function may give you some ideas.
This is a self-testing function; drag the commented macro outside of the function then de-comment the macro. Run the test macro until it works, then make changes to the function and insert new test lines and rerun the test macro. Comment the macro and drag it back into the function.
Cheers, Chris
Attached Files
File Type: txt Public Function blnStyleFoundInUseI.txt (1.5 KB, 13 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA detecting style used Need help detecting the reason for a strange behavior of a UDF soroush.kalantari Excel Programming 9 08-12-2022 07:05 PM
Detecting Write Access Password azizrasul PowerPoint 0 04-05-2021 10:56 AM
Detecting an active instance of Excel from Word VBA Sorcerer13 Word VBA 17 06-02-2014 02:48 AM
Detecting last cell within a block Funk Excel 12 10-01-2013 04:26 AM
VBA detecting style used detecting triggers yisuz PowerPoint 1 05-15-2012 09:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:00 AM.


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