Adding a dialog box to a macro

I'm recording a macro that inserts WordArt text into merged cells after rotating the text. Each execution, the text will be slightly different. I want a dialog box to pop up during the run so I can input the batch number, and have Excel do the rest.

1. What is the command to call up a dialog box?
2. Can I insert the return value of the dialog box into the Word Art window?

As for 2, I realized that the copy and paste procedure is inactive once the WordArt box is up. In fact, I've had other problems with pasting in text in the middle of a macro.

Gary

To use in input box, you can use:

Please Login or Register  to view this content.

Then, you can use the strWord variable to use in WordArt:

Please Login or Register  to view this content.

HTH,
Jason

Jason,

I pasted in your code into a new macro, but the second part is appearing in red and when i ran it it gave me a syntax error on that line. I did declare the strWord as String, but this still happened.

btw, what does HTH stand for?

Gary

That worked. The only thing now is that I wanted a carriage return between the words "batch" and "xxxx" in the dialog box.

Gary

I attached the two files again. The code crashes now that I've upgraded to office '07. The macro is stored in batchinsertwheader2.xls, but the data is in Book5.xls. so, both need to be open to run it. It's macro 7.

Thx,

Gary

Can someone please take a look at my code? It's been a while.

Gary