To Place Button in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Data in Four Sheet for Data Enter Operator ,Data Operator Enters the
data in all these sheets of accounts for each year ,At the end of year Data
Operator Wants to Clear all the data at once ,so i need a Button to clear
all the data in all sheet at 1 time,Data Operator should not go to each
column n row to delete as data is very big.

So ls guide how to place a single button to clear all data in all sheet ??

Husain Nagri
(e-mail address removed)
 
Add a control button by adding control command toolbox (View - Toolbars -
Command Toolbox). Add Command button to worksheet. Then double click button
and add code to the VBA window.

Private Sub CommandButton1_Click()
Sheets("Sheet1").Cells.ClearContents
Sheets("Sheet2").Cells.ClearContents
Sheets("Sheet3").Cells.ClearContents
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Compile Data from Different Sheets 2
Mid column sum formulas with varied ranges to sum 17
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to hide password? 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Best tool to recover PST files in 2026 1
hide multiple worksheets based on a formula value in one cell 1
Auto Copy Data from one worksheet to another 1

Back
Top