VBA Looping Presentation

[CeaserHockey]

Dear Excel Wizards,

I am currently a student taking my first class on visual basic. Our class's first project is to create a looping presentation using VBA. Basically, we need to write a code that uses the Loop until function. It is a very open ended question and it is open to creative minds.

I am not very creative however, and don't know what I should make for this project. The guidelines were that the teacher wants us to create something that will "impress" him. Does anyone have any good ideas for a looping presentation that is both suitable for a beginner, but will impress the teacher?

Thanks!!!

P.S if you want to share code or instructionto get a beginner started feel free

 

[Michael M]

Have a look at the Do While..and..Do Until functions in Vba
Examples are here

https://www.excelfunctions.net/vba-loops.html

And i'd suggest using a Message Box at the end to show your final "result"

 

[CeaserHockey]

Hi Michael. Thanks for the response. I have a pretty good idea on what the functions to use. I was mainly wondering if anyone had ideas for a project for a beginner to tackle to try ti impress their professor. Maybe something someone's done in the past.

 

[Michael M]

create something that will "impress" him.

I'm guessing he wants something original....not something someone else has already done !!