Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2022, 07:58 AM
rollis13's Avatar
rollis13 rollis13 is offline Applying a VBA code to current paragraph without being selected Windows 10 Applying a VBA code to current paragraph without being selected Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 143
rollis13 will become famous soon enough
Default


Here you will find how to apply your macro to the current paragraph LINK .
The linked macro will automatically select the current paragraph if you substitute:
Code:
Debug.Print GetParagraphIndex(r)
with:
Code:
ActiveDocument.Paragraphs(GetParagraphIndex(r)).Range.Select
Once the paragraph is selected you can apply your macro to Find/Replace (even if your macro doesn't seem to work for me??!!).

If it does what you need then you can easily merge the codes into a single Macro + Function and assign it to a shortcut key.
Reply With Quote
  #2  
Old 10-14-2022, 09:46 AM
laith93 laith93 is offline Applying a VBA code to current paragraph without being selected Windows 10 Applying a VBA code to current paragraph without being selected Office 2019
Competent Performer
Applying a VBA code to current paragraph without being selected
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default

Quote:
Originally Posted by rollis13 View Post
Here you will find how to apply your macro to the current paragraph LINK .
Thanks for your reply,
I followed the link and made the code
It works fine, but the button for this code requires clicking on it twice
first for selecting the current paragraph, and the second for applying the VBA code.
However, it's ok
but what if I want to run the code at all in just single click
Thanks
Reply With Quote
Reply

Tags
find & replace, word 19, word vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Applying a VBA code only on a selected table RobertDany Word VBA 5 10-25-2021 09:28 PM
Applying a VBA code only on a selected text or range RobertDany Word VBA 2 10-09-2021 08:31 AM
Applying a VBA code to current paragraph without being selected applying heading style within paragraph using macro cheech1981 Word 8 08-23-2017 03:07 PM
Applying a VBA code to current paragraph without being selected Applying style to first part of paragraph foxtrot Word 3 07-24-2012 07:30 AM
Does Word do this when applying Styles to a paragraph a second time? Bobosmite Word 2 04-17-2012 02:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 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