However in most cases we don’t need to use Value as this is the default property. We can also write this line like this Sheet1.Range( "A1").Value = 5
Let’s look at the line of code we used in the previous section of this VBA Tutorial Sheet1.Range( "A1") = 5 You should see “Some text” in cells B1, 5.55 in the cells C3 to E5 and the current time and date in the cell F1. Add each of the following lines to your sub, run the sub and check the results.Note: If you don’t place the cursor in the sub, VBA will display a list of available subs to run.
Select Run->Run Sub/Userform from the menu(or press F5).