Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print

Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print out every possible combination of first and middle names. These input names will need to appear in your workbook somewhere. (Make sure you type the list of first and middle names in your workbook) Then, output every possible combination of first and middle names somewhere in the worksheet. Your program should work correctly with more or less first names and middle names. Below is an example input and output. To save space, only the names associated with the first two first names are shown in the example output.

To explain some more, take 'Penelope' from the first name list and combine it with all middle names in the range and continue till there are no more names in the range of first names.

First names Middle names
Penelope Jill
Gwyneth Diane
Alice Heidi
Anna Lilly
Victoria

Please Post a Screenshot of the VBA code

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions