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,

Please Login or Register  to view this content.

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.