msgbox with cell reference

[Legacy 287389]

Hi good people!,

I found tons of examples on the net but not one where the cell value to be displayed in the msgbox, is the is in the beginning of the code. I have this:

Sheets("Scheduler").Activate
MsgBox (Range("AB2").Value & " Records Found And Printed")

The message box does not show the value in cell AB2. it only returns

Records Found And Printed

.

thanx for the help!

 

[Michael M]

Try....but make sure there is actually something in "AB2"

MsgBox (Sheets("Scheduler").Range("AB2").Value & " Records Found And Printed")

 

[GTO]

Try:

Sub example()
  MsgBox ThisWorkbook.Worksheets("Scheduler").Range("AB2").Value & " some text"
End Sub

Hope that helps,

Mark

 

[Legacy 287389]

That did it, Thanx Michael M

 

[Legacy 287389]

Hi GTO, thanx that also worked...do appreciate!

 

[GTO]

Hi juriemagic,

I failed to mention that I would suggest against including the parentheses unless you using the return value of the MsgBox, like:

Option Explicit
  
Sub example()
Dim RetVal As VbMsgBoxResult
  
  RetVal = MsgBox(ThisWorkbook.Worksheets("Scheduler").Range("AB2").Value & " some text", vbYesNo Or vbQuestion, "Do we want to?")
  
  If RetVal = vbYes Then
    MsgBox "Do something here..."
  End If
  
  'Or... just use the return of the MsgBox directly, like
  
  If MsgBox(ThisWorkbook.Worksheets("Scheduler").Range("AB2").Value & " some text", vbYesNo Or vbQuestion, "Do we want to?") = vbYes Then
    MsgBox "Do something here..."
  End If
  
End Sub

For an explanation as to the whys, check out: Quick VBA Tip: Parentheses | Daily Dose of Excel

In particular, reading Rick Rothstein's comments at about post #6.

Hope that helps,

Mark

 

[Legacy 287389]

GTO,

thanx for the extra info, the message box return info is purely for confirming how many sheets had been printed. it's not really used for anything else...thanx a lot..