getting value from names cell into MSGBOX 1

[MCubitt]

I have a named cell and want to embed teh value inside the cell into a msgbox text.

EG:
dummy = MsgBox(Cells(ReportTitle).Value & vbCr & vbCr & HelpText, vbOKOnly, ReportTitle)


Where ReportTitle is the named cell (and so is HelpText)









Applications Support
UK

 

[TonyJollans]

Hi MCubitt,

Try this instead:
[blue][tt] dummy = MsgBox([/tt][red][tt][ReportTitle][/tt][/red][tt].Value & vbCr & vbCr & HelpText, vbOKOnly, ReportTitle)[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[MCubitt]

Tony,

Thank you, I never knew that so that'll be what I have learned today.

regards


Applications Support
UK