View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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