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.

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

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
>

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

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
>