Please help to write a VBA code in Excel for the following. • The lottery draws a number that is the winning number • The number should be between 0 and 999 • Have someone play • The person tells how many tickets they want • The person always does “quick pick” (let the computer pick the number for them) and gets one number between 0 and 999 for each ticket bought • The program reports how many tickets win of the ones bought • NOTE: A ticket “wins” if it matches the winning number previously chosen • Write working code with at least one function and one sub other than “main”
Control structures
Control structures are block of statements that analyze the value of variables and determine the flow of execution based on those values. When a program is running, the CPU executes the code line by line. After sometime, the program reaches the point where it has to make a decision on whether it has to go to another part of the code or repeat execution of certain part of the code. These results affect the flow of the program's code and these are called control structures.
Switch Statement
The switch statement is a key feature that is used by the programmers a lot in the world of programming and coding, as well as in information technology in general. The switch statement is a selection control mechanism that allows the variable value to change the order of the individual statements in the software execution via search.
Please help to write a VBA code in Excel for the following.
• The lottery draws a number that is the winning number
• The number should be between 0 and 999
• Have someone play
• The person tells how many tickets they want
• The person always does “quick pick” (let the computer pick the number for them) and gets one number between 0 and 999 for each ticket bought
• The program reports how many tickets win of the ones bought
• NOTE: A ticket “wins” if it matches the winning number previously chosen
• Write working code with at least one function and one sub other than “main”
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images