I have a macro that fills in a template that is updated each month.

The template has all the formatting, the macro will fill in the template
each month with data. After this is done, I'd like the user to change Range
"A4" and the footer to February 2007 etc. each month via an input dialog box
or list box.

Can anyone help me. I've started with .AddItem for each month to start a
list box. But I'm stuck on how to proceed. Any help will be appreciated.

I solved my problem.

Dim MonthYear As String, Title As String
Dim ChangeMonth As Variant
MonthYear = "Enter the Month and Year of this Report"
Title = "Update Month"
ChangeMonth = Application.InputBox(MonthYear, Title)
Worksheets("Detail").Range("A4").Value = ChangeMonth
Worksheets("Summary").Range("A4").Value = ChangeMonth

"MacroLearning" wrote:

I have a macro that fills in a template that is updated each month.

The template has all the formatting, the macro will fill in the template
each month with data. After this is done, I'd like the user to change Range
"A4" and the footer to February 2007 etc. each month via an input dialog box
or list box.

Can anyone help me. I've started with .AddItem for each month to start a
list box. But I'm stuck on how to proceed. Any help will be appreciated.