Question: Write a VBA program to find out the Chinese Zodiac sign for a given year. This is based on a 12-year cycle, with each year

Write a VBA program to find out the Chinese Zodiac sign for a given year. This is based on a 12-year cycle, with each year represented by an animal in this predefined order: Monkey, Rooster, Dog, Pig, Rat, Ox, Tiger, Rabbit, Dragon, Snake, Horse and Sheep. Given that Year 1900 is the year of the Rat. Requirements: 1. Accept Year from InputBox(); 2. Use array programming method to complete this assignment question; 3. Convert the Year information to the corresponding Chinese Zodiac sign; 4. Display the result in a MsgBox()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A basic wooden railway set contains the pieces shown in Figure 3.32. The task is to connect these pieces into a railway that has no overlapping tracks and no loose ends where a train could run off...

PYTHON PYTHON Write a program to find out the chinese zodiac sign for a given year. The Chinese zodiac sign is based on a 12 year cycle, and each year in this cycle is represented by an animal-...

Write a program to find out the chinese zodiac sign for a given year. The Chinese zodiac sign is based on a 12 year cycle, and each year in this cycle is represented by an animal- monkey, rooster,...

I need help with this Java programming assignment: Write a program that prompts the user to enter the name of any 30-day month. The program should respond positively or negatively as appropriate. Use...

in java pls (ChineseZodiac.java) Write a program to find out the Chinese Zodiac sign for a given year using an array of strings to store the animal names. The Chinese Zodiac is based on a twelve-year...

Requirements: Given a poorly written Python script, poor _ chinese _ zodiac.py , that determines the Chinese Zodiac sign for a year input by the user, write a well - structured Python script, chinese...

Please show input and output clearly Lab Assignment 3- Chinese Zodiad CSCI 251 Problem Statement The Chinese Zodiac is based on a twelve-year cycle, with each year represented by an animal: monkey...

PHP 1.Write a php script that to displaythe Chinese Zodiac sign from 1-11. The Chinese Zodiac sign is based on a twelve-year cycle, with each year represented by an animal monkey,rooster, dog, pig,...

How to modify a Chinese program to allow users to choose between Chinese, Japanese, or Vietnamese zodiacs. I can do the first portion, however, the modification portion keeps getting me stumped. I...

In C++ please! Chinese Zodiac assigns an animal and its reputed attributes to each year in a repeating 12-year cycle . It is known that 2008 is a Rat year, followed by Ox (2009), Tiger(2010),...

You are an employee who has just discovered that an e-mail message you thought you sent to your close friend at work was sent to an entire department. In this message, you disclose the fact that you...

An analysis by Deep Earth Oil Refinery recommends buying oil containers from an outside supplier for $18 per container. The analysis shows the company would be paying $5 less than it costs to...

A company's operations are most likely to be taken over by a host government when _ _ _ _ _ _ _ _ .

The organization will pay 50% of the cost of the AD&D premiums and 50% of the cost of the vision care premiums, with the employees paying the other 50% of each premium. The Director of Finance, Tina...

Take a ten-minute walk through the halls of your school. Look for posters or other items that fall into the category of positive/neutral news. Prepare a table that shows each document type, its...

Obtain and examine the letterhead stationery and envelopes used at your school or at another organization your instructor selects, and then answer the following questions: (Objectives 1, 4, and 6) a....

Which of the following paragraphs would be more appropriate for the sales appeal of a request approval? Explain why. (Objective 3) Mr.Williams, I want to invite you to our annual sale.We have many...