Vba

[fb11]

Hi All

I'm an undergraduate student studying Info Systems in Chicago and currently in a VBA excel class and am hoping to learn more!

Fb11

[fb11]

Hi all,

am looking to complete this assignment but I am not sure how to. I was hoping to do something with Frequent Flyer Miles. One sub would represent the number of individuals (Indv 2 , Indv 2, Indv 3....) and random integers that calculate the distance traveled for that individual. the second sub must be called by the first sub that activates the argument, and would represent the individual (Indv 1, Indv 2...) and their frequent flyer mile status (bronze, silver, gold, platinum... bronze being the lowest status and platinum the highest status) along with the kilometers traveled
Instructions are below:



Create a program of your own design that includes each feature specified below.

Be sure to include
a detailed description of what the program is designed to do, and
the Excel workbook with the code you have created.

Your program must include:

At least two subs, one of which calls at least one other sub, passing at least one argument.
A function that has at least one argument that is called by one of the subs.
A workbook_open event

[vlady]

Welcome to the forum

[arlu1201]

You need to post your question in the forum.