ExcelBanter - MsgBox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - MsgBox (https://www.excelbanter.com/excel-programming/286718-msgbox.html)

Randal W. Hozeski

MsgBox

How do I display what is in a given cell of a sheet in
a MsgBox?

MsgBox "The value that is in cell B10 of the active
sheet is: TheResult."

and can TheResult be the cell name?
-Randy-

..

Rob van Gelder[_4_]

MsgBox

Randal,

MsgBox "The value that is in cell B10 of the active sheet is: " &
Range("B1") & "."

Rob

"Randal W. Hozeski" wrote in message
news:6QkJb.718219$HS4.5175936@attbi_s01...
How do I display what is in a given cell of a sheet in
a MsgBox?

MsgBox "The value that is in cell B10 of the active
sheet is: TheResult."

and can TheResult be the cell name?
-Randy-

.

All times are GMT +1. The time now is 06:03 AM.