I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

From the forms toolbox put a button on your sheet and when the popup window
comes up click on new macro and add the following code.

Range("B1:B12").Select
Selection.ClearContents

Mike

"traveye" wrote:

I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

right click sheet tabview codeinsert this. Now when you DOUBLE click cel
a1 b1:b12 cleared

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address = "$A$1" Then Range("b1:b12").ClearContents
End Sub

However, I suspect you did NOT fully state your problem.

--
Don Guillett
SalesAid Software

"traveye" wrote in message
...
I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

Thanks, it works great!

"Mike" wrote:

From the forms toolbox put a button on your sheet and when the popup window
comes up click on new macro and add the following code.

Range("B1:B12").Select
Selection.ClearContents

Mike

"traveye" wrote:

I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

How Can I do that for multiple cells that are not contiguous. I am a novice.
--
dow


"Mike" wrote:

From the forms toolbox put a button on your sheet and when the popup window
comes up click on new macro and add the following code.

Range("B1:B12").Select
Selection.ClearContents

Mike

"traveye" wrote:

I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

range("b1:b2,C17:d99,g13,z:z,105:105").clearconten ts

You don't need to select a range to clear it.

dow wrote:

How Can I do that for multiple cells that are not contiguous. I am a novice.
--
dow

"Mike" wrote:

From the forms toolbox put a button on your sheet and when the popup window
comes up click on new macro and add the following code.

Range("B1:B12").Select
Selection.ClearContents

Mike

"traveye" wrote:

I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?

--

Dave Peterson