Code for using prompt boxes within a sheet?

Hi Sean,

That is great - thank you.

Just a quick question, after using your code, I think I'd rather have cell A1 to be the same as the name of the sheet that I specify in the first step.

Please Login or Register  to view this content.

Do you know how the above will need to be modified so that after I re-name the sheet, that same name is copied into cell A1?

Also, I'm just curious, but if cell A1 on the template has the following text in it "Name", can the code be written so that whatever I enter in the prompt box is just added onto the end of the the text in A1?

Thanks,

Sorry, my previous post didn't explain what I was after very well.

Please Login or Register  to view this content.

After entering the name of the tab and having that displayed also in cell A1. I would like another prompt box that asks for a date and then places that value in cell A2 along with the text "Beginning from". I've tried to describe it in the code above, but I know it's not correct. How do I distinguish between the two prompt boxes?

Thank you.

Sean,

Thank you for all of your help. Greatly appreciated.