Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 08-30-2022, 10:44 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

Quote:
Originally Posted by macropod View Post
You will need to explain what you mean by that - including examples.

OK, thanks, I'll try to be clearer. Say we offer red, white and blue mugs in 3 different patterns, dot, star and check.


Thus VAR1 = red | white | blue
VAR2 = dot | star | check


Output will be 9 lines: (3xVAR1) mug with a (3xVAR2) pattern. Adding an n-variation VAR3 would produce 3 x 3 x n lines etc.

Before:
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern
VAR1 mug with a VAR2 pattern

=========================
VAR1 can have the value red, white or blue
VAR2 can have the value dot, star or check, so
=========================

After:
Red mug with a dot pattern
Red mug with a star pattern
Red mug with a check pattern
White mug with a dot pattern
White mug with a star pattern
White mug with a check pattern
Blue mug with a dot pattern
Blue mug with a star pattern
Blue mug with a check pattern
Reply With Quote
 



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 03:20 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