VBA

[soumyajit]

I have data in sheet1 as given bellow;

435 4564 65464 6546

456 6767 767 5677

now i just wanted to know how do i clear those data with a clear button using VBA & how do i create this button in sheet1.

 

[DaveTurton]

Alt & F11 to get to VBA


New module


Code:


Sub clear_cells ()


Cells.clear


End Sub


On your sheet. Toolbars-forms.


Put a button on


It will ask you to assign a macro. Choose Clear_cells