Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write (not record) a Macro, QUESTION8, that will put the employees month of birth in column Birth Month, for each employee in the database. Month

Write (not record) a Macro, QUESTION8, that will put the employees month of birth in column Birth Month, for each employee in the database. Month should be in text, e.g., March, May etc. (Hint: Must write VBA code from scratch). Create macro button in Database sheet. PLEASE PROVIDE VBA CODE NOT A FORMULA FOR CELL.image text in transcribed

M A B D E F G . | J K L Create Macro buttons for Question 3 to 12 (except question 11 as that question doesn't need macro button) below in the g 1 2 2 3 4. 6 Q8 Q7 New Salary 2 Birth Month N200 ~ Emp ID 1011 1012 1041 1054 1055 1075 1152 1153 1167 Age 56 36 55 33 53 41 49 Q6 Years In Service New Salary 1 21 15 18 11 21 14 21 57 12 19 50 50 1168 21 1169 42 Last Name First Name Department Gorton Hazel Accounting Preston Liza Engineering Tercan Robert Rand D Smith Howard Art Albert Maxine Marketing Kane Sheryl Art Henders Mark Accounting Plant Allen Accounting Berwick Sam Marketing Asonte Toni Engineering Dorfberg Jeremy Engineering Cooper Linda Admin Simpson Sandrae Engineering Richards Phillip Accounting Sindole Randy Marketing Smith Ellen Engineering Cane Nate Marketing Vuanuo Tuome Engineering Selznick Anna Accounting Cash Mary Engineering Szcznyck Tadeuz Engineering Kaneko Midori Rand D Lampstone Pete Marketing 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Division Copier Printer Printer Copier Copier Printer Printer Printer Copier Fax Copier Fax Copier Printer Fax Fax Printer Printer Copier Printer Copier Fax Fax Salary $27,597.85 $43,394.15 $28,043.68 $25.176.06 $26,040.56 $23,239.44 $26,646.20 $28,043.68 $31.913.88 $63,035.88 $58,002.05 $26.113.86 $34,854.20 $30,451.68 $27,081.04 $32.410.85 $43,486.95 $55,410.85 $31,539.24 $49,872.15 $59,362.20 $28,043.68 $64,689.00 Hire Date 2/3/2000 1/26/2006 4/16/2002 4/16/2009 4/8/1999 8/7/2006 1/21/2000 1/13/2009 4/18/2001 4/10/1999 10/13/1998 1/3/2005 12/21/2005 12/13/1993 8/6/2008 10/4/1986 9/26/2002 2/22/2009 2/14/1999 5/11/1999 4/16/1995 4/8/1998 9/8/1985 Birth Date 11/21/1964 12/2/1984 9/21/1965 8/9/1987 8/20/1967 8/28/1979 10/23/1971 11/3/1963 9/28/1970 7/8/1970 7/12/1978 10/1/1966 9/16/1985 9/24/1965 6/25/1961 11/2/1965 11/13/1954 5/6/1964 9/23/1968 5/21/1964 10/7/1965 10/18/1965 9/23/1958 22 16 54 35 55 15 27 12 59 55 66 34 18 1290 1299 1300 1301 1310 1311 1329 1330 1331 1333 1334 1426 56 11 22 52 56 21 25 55 55 22 62 35

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_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

What are the components of operating expense? LO1.

Answered: 1 week ago

Question

Outline the elements in organizational cultures.

Answered: 1 week ago

Question

love of humour, often as a device to lighten the occasion;

Answered: 1 week ago

Question

orderliness, patience and seeing a task through;

Answered: 1 week ago

Question

well defined status and roles (class distinctions);

Answered: 1 week ago