{"id":462,"date":"2013-03-03T06:01:10","date_gmt":"2013-03-03T06:01:10","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=462"},"modified":"2020-04-23T10:56:07","modified_gmt":"2020-04-23T10:56:07","slug":"excel-vba-lesson-18-excel-vba-objects","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-18-excel-vba-objects\/","title":{"rendered":"Excel VBA Lesson 18: Introduction to Excel VBA Objects Part 2"},"content":{"rendered":"

<<Lesson 17>><\/a> [Contents] <\/a><<Lesson 19>><\/a><\/strong><\/h4>\n

In lesson 13, we have learned the concepts of Excel VBA objects. You have also learned that an Excel VBA object has properties and methods. We have already dealt with properties and we shall learn about methods in this lesson.<\/p>\n

18.1: Methods<\/strong><\/h3>\n

A method of an Excel VBA object normally do something or perform certain operations. For example, ClearContents is a method of the range object that clears the contents of a cell or a range of cells. For example, You can write the following code to clear the contents of certain range:<\/p>\n

Example 18.1<\/strong><\/h4>\n

‘Clear contents from cells A1 to A6
\nPrivate Sub CommandButton1_Click()
\nRange(\u201cA1:A6\u201d).ClearContents
\nEnd Sub
\nYou can also let the user select his own range of cells and clear the contents by using the InputBox function, as shown in Example 18.2
\n