Put a dialog box in a macro

[JOHNAK27]

Hi all

I want to run simple macro, where it copies a sheet into another new workbook. I want it to prompt the user to choose a specific sheet in the workbook to copy.

See below basic macro, at the moment its pointing to a particular sheet, I want the user to enter 04-07-13 then say OK and macro continues.

Sub Macro2()
'
Sheets("04-07-13").Select
Sheets("04-07-13").Copy
Range("A1").Select

Windows("xxxxx xxxxx TEMPLATE.xlsm").Activate

End Sub

Many thanks, John

[Jakobshavn]

Request the tab name as a string:

Please Login or Register  to view this content.

[Andy Pope]

something like this

Please Login or Register  to view this content.

[JOHNAK27]

Great thank you .... Andy & Jakobshavn ....