Add a message box before running a macro

[RinorM]

Hi! I need to add a message box before you can run the macro. It is going to ask the name of the person who runs the macro. When a person writes the name this name is going to be exported to a cell C1 in Sheet "Rapport". How can I create this one?

Thank you very much.

[Mumps1]

This will ask for a name and then enter that name in C1 of sheet "Rapport". Is this what you wanted?

Please Login or Register  to view this content.

[Kaper]

Try something like:

Please Login or Register  to view this content.

PS. name is so often used as property of several objects, that it is better to avoid using it as your variable name.

[BadlySpelledBuoy]

Please Login or Register  to view this content.

[RinorM]

This worked very well, thank you. The only thing is that my macro creates a report from Excel to Word. I want that when you run the macro, enter your name, then create the report with the name inserted in the report. Now its in the wrong order. Now it first creates the report then the name goes into cell C1.

whole code:

Please Login or Register  to view this content.

[RinorM]

I managed to fix it! I just changed the order inside of the code

[RinorM]

Thank you very much for the help guys.