Message Box To A Cell Reference

davidhall80

Well-known Member
Joined
Jul 8, 2006
Messages
663
I would like to insert a message box in my macro and I want the message to be whaever is in cell A1. Is this possible? Thanks in advance
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Code:
Sub tst()
MsgBox Sheets("Sheet1").Range("A1").Value
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,970
Messages
5,575,287
Members
412,653
Latest member
JyothiGrace
Top