Hi there,

Is it possible to input an ActiveX control text box in my spreadsheet to change a certain name within my macro? For example,

If Range("C63").Value = "1" Then
    Windows("2.xls").Activate
    Range("B3:J3").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("WEEK40'11").Activate
    Range("C4").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=True
    End If

I want to change the WEEK40'11 inside this macro to WEEK41'11 when I type in WEEK41'11 to the ActiveX control text box.

Please help, thanks.