Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2022, 04:23 AM
Edit4Fun Edit4Fun is offline VBA to replace a repeated single variable with variable from a list Windows 10 VBA to replace a repeated single variable with variable from a list Office 2016
Novice
VBA to replace a repeated single variable with variable from a list
 
Join Date: Aug 2022
Posts: 7
Edit4Fun is on a distinguished road
Default

Thank you, both


For context, I am looking to semi-automate the titling, description and tag-writing process for a series of related product designs. Let's say mugs with different cat breeds on them as an example. So an entry might be:


Cute [BREED] mug


White ceramic mug with a [BREED] design
[BREED] cat, [BREED] gift, cat lover gift, Christmas gift


and that format would be repeated for each breed I've designed for. So far, I've been copy-pasting the sample entry to create a list with as many entries as I have breeds, copying the breed name from a breed-name list (in a separate document), highlighting the first entry, FR [BREED] with ^c, then rinse and repeat to the end of the list. Since the entries all have the same format, the number of replacements would be constant for each search (4 in this case), and easily varied if necessary for a different design next time.

Last edited by Edit4Fun; 08-29-2022 at 04:26 AM. Reason: clarity
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable shimulsiddiquee Excel 1 05-16-2017 07:39 AM
VBA to replace a repeated single variable with variable from a list ord vba replace the variable text with variable images to make offer products with images tanzinim Word VBA 4 12-30-2015 01:40 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge Berryblue Mail Merge 1 11-13-2014 05:36 PM
VBA to replace a repeated single variable with variable from a list Run-time error 91 object variable or with block variable not set JUST ME Word VBA 4 03-25-2014 06:56 AM
VBA to replace a repeated single variable with variable from a list Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM

Other Forums: Access Forums

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