Hi,

At the end of my macro I've got a simple message box appearing stating that
the process has finished.

I need another one to appear after that one and I need it to have A Report
Title and Report Number in the box.

The report title is in Cell A2 and the Report Number is in K2.

Is there any way of referencing cells in the code for a Message box?

msgbox("Report Title : " & Range("A2") & "; Report Number : " & Range("K2"))

"N1KO" wrote:

Hi,

At the end of my macro I've got a simple message box appearing stating that
the process has finished.

I need another one to appear after that one and I need it to have A Report
Title and Report Number in the box.

The report title is in Cell A2 and the Report Number is in K2.

Is there any way of referencing cells in the code for a Message box?

Thanks for this Joel,

I've decided to have a form created and have the Number and Title on top of
each other rather than a message box.

"joel" wrote:

msgbox("Report Title : " & Range("A2") & "; Report Number : " & Range("K2"))

"N1KO" wrote:

Hi,

At the end of my macro I've got a simple message box appearing stating that
the process has finished.

I need another one to appear after that one and I need it to have A Report
Title and Report Number in the box.

The report title is in Cell A2 and the Report Number is in K2.

Is there any way of referencing cells in the code for a Message box?