Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2018, 11:55 PM
puff puff is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2013
Advanced Beginner
Create a dialog to combine several replacing process
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Default Create a dialog to combine several replacing process

Hi all. I currently have many replacing methods done by the wild card. And I'm thinking whether it's possible to make a "summary" macro that can provide a dialog with several checkboxes where I can choose different combinations of the replacing methods and do them at once. I know the replacing can be recorded as macro, you can invoke macros within another macro, and checkboxes work on UserForms. But before I get any further, is it the correct way? Thank you.
Reply With Quote
  #2  
Old 02-28-2018, 12:08 AM
macropod's Avatar
macropod macropod is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You've started multiple threads lately on what appear to be closely related issues. Perhaps you could explain what it is you're trying to achieve, rather than serving it up piecemeal in different threads that don't give an overall context.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-28-2018, 11:08 AM
puff puff is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2013
Advanced Beginner
Create a dialog to combine several replacing process
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Default

Sorry for shooting out questions. I'm doing some text processing on various documents and I kind of want to develop a tool rather than find a solution to a specific project. Basically, I will always do a subset of several certain replacing and I want to summarize them in a userform by checkbox, such that they're easier to use when I process different documents with different issues.
Reply With Quote
  #4  
Old 02-28-2018, 12:12 PM
puff puff is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2013
Advanced Beginner
Create a dialog to combine several replacing process
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
You've started multiple threads lately on what appear to be closely related issues. Perhaps you could explain what it is you're trying to achieve, rather than serving it up piecemeal in different threads that don't give an overall context.
Now I have made a userform with some help from several tutorials and it works fine. Yet, one issue is that all the options can only perform one at a time rather than a combination. From a tutorial, I know that I can write all the combinations with "IF" and subsequent commands. But if I have lots of options, I will write tons of combinations. Is there a way to get around of this problem?
Reply With Quote
  #5  
Old 02-28-2018, 03:02 PM
macropod's Avatar
macropod macropod is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You could employ a userform, with selectable options. See attached.

Note: the 3rd option runs the F/R code from https://www.msofficeforums.com/word-...er-number.html
Attached Files
File Type: docm Demo.docm (32.5 KB, 15 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 02-28-2018, 11:51 PM
gmayor's Avatar
gmayor gmayor is offline Create a dialog to combine several replacing process Windows 10 Create a dialog to combine several replacing process Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You might find http://www.gmayor.com/document_batch_processes.htm useful as it provides assorted replacement functions, including from a list of replacement items.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #7  
Old 03-01-2018, 07:32 PM
puff puff is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2013
Advanced Beginner
Create a dialog to combine several replacing process
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
You could employ a userform, with selectable options. See attached.

Note: the 3rd option runs the F/R code from https://www.msofficeforums.com/word-...er-number.html
I already understand how the checkboxes work in a userform. The problem I have now is how you efficiently code each scenario. For example, a userform with 3 options A., B., and C.. The tutorial I watched said that you need to specifically code for every combination: not only the 3 respective options but also like "A. and B."
If I have 5 checkboxes as a group, I will have to code for C(5,5)+C(5,4)+C(5,3)+C(5,2)+C(5,1)+C(5,0)=1+5+10+1 0+5+1=32 conditions. Is there a way to overpass this issue?
Reply With Quote
  #8  
Old 03-01-2018, 08:33 PM
macropod's Avatar
macropod macropod is offline Create a dialog to combine several replacing process Windows 7 64bit Create a dialog to combine several replacing process Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You're overcomplicating things. Simply let the code call the corresponding subs in order. As shown in the demo I posted, you can check any combination of the available options and whichever ones you've checked will be run in order.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
PMI process groups with MS Project Kotor Project 3 03-12-2016 11:52 AM
Create a dialog to combine several replacing process Process Automation saurabhlotankar Excel Programming 10 06-03-2015 05:50 PM
Create a dialog to combine several replacing process Outlook process not closing Alan.bailey Outlook 2 02-12-2015 08:56 AM
Create a dialog to combine several replacing process Configuration Process dialog box repeatedly appears Colonel Biggs Office 4 12-09-2011 02:16 PM
Configuration process problem Dunn2009 Outlook 0 10-02-2009 02:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.


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