Simple Message Box

  • Thread starter Thread starter N1KO
  • Start date Start date
N

N1KO

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"))
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List found strings on sheet 34
Message Box Q 4
Requiring Cell Input - Show Error Message 1
find and scroll to cell string value in Excel 2
Multiple VByesno Message boxes no working 2
Error Message - Macro to Unlink MS Queries from Workbook 0
How to use OFFSET in VBA 1
Macro will copy formula instead of value 6

Back
Top