MonthName Function

[Bmaho]

Can anyone help me write a macro for a school project I am working on? I think I need to use a MonthName function, I'm not sure how though. The question is:

Write a Macro, that will put the employee’s month of birth in column “Birth Month”, for each employee in the database. Month should be in text, e.g., March, May etc. Must write VBA code from scratch.

The following is a sample of the worksheet, The Range for the following on my worksheet is A8:M61 and the "Birth Month" column where the name of the month goes is M8.

Emp ID

Last Name

First Name

Department

Division

Salary

Start Date

Birth Date

Age

Years In Service

New Salary 1

New Salary 2

Birth Month

1011

Gorton

Hazel

Accounting

Copier

$27,597.85

2/3/2000

11/21/1964

53

18

1012

Preston

Liza

Engineering

Printer

$43,394.15

1/26/2006

12/2/1984

33

12

1041

Tercan

Robert

R and D

Printer

$28,043.68

4/16/2002

9/21/1965

52

16

1054

Smith

Howard

Art

Copier

$25,176.06

4/16/2009

8/9/1987

30

9

1055

Albert

Maxine

Marketing

Copier

$26,040.56

4/8/1999

8/20/1967

50

19

1075

Kane

Sheryl

Art

Printer

$23,239.44

8/7/2006

8/28/1979

38

11

1152

Henders

Mark

Accounting

Printer

$26,646.20

1/21/2000

10/23/1971

46

18

1153

Plant

Allen

Accounting

Printer

$28,043.68

1/13/2009

11/3/1963

54

9

1167

Berwick

Sam

Marketing

Copier

$31,913.88

4/18/2001

9/28/1970

47

17

1168

Asonte

Toni

Engineering

Fax

$63,035.88

4/10/1999

7/8/1970

47

19

<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

I may be mistaken, but would Format only reformat the dates in "Date of birth" (column H) to display the month name?

No, this is not cell formatting (which is a worksheet functionality), rather, Format is a VBA function and, like all functions, it returns a value that can be used in anyway you see fit. Format is a powerful function (it can take numbers, dates and text and manipulate them is quite a few different ways) which, one day, you should spend time learning, but now is apparently not the time as your professor has you on the MonthName function for now.

What I am trying to do is use the dates in column "H" to display the "birth month" in column "M". Prior to trying to add Format to the code.

You are getting a full date from Column H, but you need to output to a different column the name of the month for that date. The first argument for the MonthName function is a number... the number of the month for the cell containing the date in Column H that your loop is currently iterating. What function did you learn that will return the month number from a date? Use that function call as the first argument for the MonthName function and then assign that MonthName expression to the active cell inside your loop.