Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Use QuestionToMessageBox with Input for Cell
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?") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Use QuestionToMessageBox with Input for Cell
Thanks, Claus, it worked perfectly!
The little piece of my VBA ended up looking like: & Range("Chart!nameInsert") & |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input cell should display a percentage of input value in the cell | Excel Discussion (Misc queries) | |||
Cell Color changes On Input even if new input matches default | Excel Programming | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel |