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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

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,111,911
Messages
5,541,543
Members
410,549
Latest member
Anaarchie
Top