Generally speaking, you do three main things with CellsĮxcel has a number of methods for accessing cells such as Range, Cells and Offset.These can cause confusion as they do similar things and can lead to confusion Almost everything you do in Excel starts and ends with Cells. These three elements are the Workbooks, Worksheets and Ranges/Cells. Cells are by far the most important part of Excel. This is the third post dealing with the three main elements of VBA. ( Note: Website members have access to the full webinar archive.) If you are a member of the VBA Vault, then click on the image below to access the webinar and the associated source code.

18 Going through all the cells in a RangeĪ Quick Guide to Ranges and Cells Function.

17 Reading a Range of Cells to an Array.

13 Reading Values from one Cell to another.

If you want a user to specify a value to enter in a cell you can use an input box. Range('A1').Value = DateĪnd if you want to enter a value in the active cell then the code you need would be like: ActiveCell.Value = Date 2.

You can also DATE and NOW ( VBA Functions) to enter a date or a timestamp in a cell using a VBA code. You can write the code like the following. In that case, you don’t need to use double quotation marks.

Now let’s say you want to enter a number in a cell. Cells(1, 1) = 'Done'īut this is recommended to use the value property to enter a value in a cell. Cells(1, 1).Value = 'Done'Īpart from this, there is one more way that you can use and that’s by not using the value property directly assigning the value to the cell. You can also use the “Cells” property, just like the following code. In the end, I have assigned the value “Done” using an equal “=” sign enclosed in double quotation marks. As you can see, I have first defined the cell address where I want to add the value, and then the value property.

Visual basic for excel cells function