This video demonstrates how to reference a cell in Excel VBA: how to enter a value in a cell and how to format it.
------------------------