Clear Contents Function

[mem_dawg]

Hi All,

Is it possible to create a function that clears the contents of a cell when the criteria is met?

For instance, if A1>0 then Clear Contents of A1.

Cheers,
mem

[royUK]

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

[mem_dawg]

Thanks Roy,

that's exactly what I needed.

cheers,
mem

[mem_dawg]

Hey Roy,

Just a quick question.. I have applied this code to several sheets which are pulling data from a macro running master sheet. Then these sheets are executing some orders automatically, my problem is this Clear Content VBA is not working automatically unless I manually change the figures. Is there any way to sort this?

cheers,
mem

[Toonies]

you could try

Private Sub Worksheet_Change(ByVal Target As Range)

[mem_dawg]

that didn't work either.. I think I need something that runs the macro every one or two seconds..