How to Use QuestionToMessageBox with Input for Cell
Hi David,
Am Thu, 9 May 2019 23:45:35 -0700 (PDT) schrieb David Godinger:
How can I put in a variable that comes from a named cell in the spreadsheet.
Here's my line, and I'd like
QuestionToMessageBox = ("Are you CERTAIN you've copied the contents of this sheet into a new one?" _
& namedCellFromSheet & " some more text?")
try:
QuestionToMessagebox = MsgBox("Are you CERTAIN you've copied the contents of this sheet into a new one? " _
& Range("Sheet1!NamedCell.Name") & " some more text?", vbYesNo, "Question")
Regards
Claus B.
--
Windows10
Office 2016
|