Delete a cell when found
 

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.

Delete a cell when found
 

Formulas can't delete cells.

And maybe you don't need VBA.

If the cell contains only the text: Past Due
Select that column
Edit|Replace
what: Past Due
with: (leave blank)
replace all

If the cell can contain other text besides that "Past Due" string:
Select that column
Edit|Replace
what: *Past Due* (the asterisks are wild card characters)
with: (leave blank)
replace all

ricksgma wrote:

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.

--

Dave Peterson

Delete a cell when found
 

Thanks dave. that works good. is there a macro or something i can make that
will do the same thing by pressing a button??


"Dave Peterson" wrote:

Formulas can't delete cells.

And maybe you don't need VBA.

If the cell contains only the text: Past Due
Select that column
Edit|Replace
what: Past Due
with: (leave blank)
replace all

If the cell can contain other text besides that "Past Due" string:
Select that column
Edit|Replace
what: *Past Due* (the asterisks are wild card characters)
with: (leave blank)
replace all

ricksgma wrote:

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.

--

Dave Peterson

Delete a cell when found
 

Record a macro when you do it manually and you'll have the code that you can
assign to the Forms toolbar button.

ricksgma wrote:

Thanks dave. that works good. is there a macro or something i can make that
will do the same thing by pressing a button??

"Dave Peterson" wrote:

Formulas can't delete cells.

And maybe you don't need VBA.

If the cell contains only the text: Past Due
Select that column
Edit|Replace
what: Past Due
with: (leave blank)
replace all

If the cell can contain other text besides that "Past Due" string:
Select that column
Edit|Replace
what: *Past Due* (the asterisks are wild card characters)
with: (leave blank)
replace all

ricksgma wrote:

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.

--

Dave Peterson


--

Dave Peterson

Delete a cell when found
 

Great. Thanks for all your help.

"Dave Peterson" wrote:

Record a macro when you do it manually and you'll have the code that you can
assign to the Forms toolbar button.

ricksgma wrote:

Thanks dave. that works good. is there a macro or something i can make that
will do the same thing by pressing a button??

"Dave Peterson" wrote:

Formulas can't delete cells.

And maybe you don't need VBA.

If the cell contains only the text: Past Due
Select that column
Edit|Replace
what: Past Due
with: (leave blank)
replace all

If the cell can contain other text besides that "Past Due" string:
Select that column
Edit|Replace
what: *Past Due* (the asterisks are wild card characters)
with: (leave blank)
replace all

ricksgma wrote:

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.

--

Dave Peterson


--

Dave Peterson