VBA Clear Contents | How to Use Excel VBA Clear Contents? - EDUCBA We will use clear contents method to clear the data from cell A1. Follow the below steps to clear the content of the cell using VBA code. Step 1: Go to developer's tab and click on Visual Basic to open VB Editor. Step 2: It will open the VB Editor for us. Click on Insert tab to insert a new module.