I have kept my explanation as simple as possible.

I tried using the macro recorder to record the code I want but didn't
understand the steps I should follow when using the recorder to achieve the
data input Month Number / Date to get the list I want as described
below........

Problem
I want to create a list of months as shown below
Column A Column B
1 Oct 04
2 Nov 04
3 Dec 04
etc..........................

At the moment I create it manually
Column A = ROW() copied down.
Column B = Custom date format mmm-yy copied down.
10 and Oct 04 copied down would produce 1 to 10 .....Jan 04 to Oct 04

Question

I have place a command button on the work sheet and named it "NewForm"

I want to create code to attach to the command button which when run will
display a form with two input boxes in sucession 1. Number of Months and 2.
Date

The result being a list of numbered months.

Any sample code / advice would be much appreciated.