Excel – How to read a value from a cell in VBA?

The default Property of a cell is the Value Property, so:

Sub ReadCell()
 msgbox Range("A1")
 End Sub

OR

Sub ReadCell()
 msgbox Range("A1").Value
 End Sub

Will both read the value of range A1 of the active sheet. If the cell to be read is on another sheet, use

Sub ReadCell()
 msgbox Sheets("Sheet2").Range("A1").Value
 End Sub