How do I put a delete button on excel that will clear the fields?
 

I need to find out how to put a button in excel that will clear all the
fields. Please help! :)

How do I put a delete button on excel that will clear the fields?
 

On Aug 1, 4:14 pm, Dave wrote:
I need to find out how to put a button in excel that will clear all the
fields. Please help! :)

Go to forms toolbar click the button field. Put the button anywhere
on your form. Now go to all of your fields and populate them. Now go
to Tools Macro Record New Macro. Now go to each populated field
and clear each one by one. Now go to Tools Macro Stop Recording
Macro. Now right click your button and assign the maqcr you just
created to it. Test it by populating the fields again and clicking
the button. Voila!!!

How do I put a delete button on excel that will clear the fields?
 

On Aug 1, 4:14 pm, Dave wrote:
I need to find out how to put a button in excel that will clear all the
fields. Please help! :)

Go to forms toolbar click the button field. Put the button anywhere
on your form. Now go to all of your fields and populate them. Now
go
to Tools Macro Record New Macro. Now go to each populated field
and clear each one by one. Now go to Tools Macro Stop Recording
Macro. Now right click your button and assign the macro you just
created to it. Test it by populating the fields again and clicking
the button. Voila!!!

How do I put a delete button on excel that will clear the fields?
 

CTRL + a(twice in 2003) then hit the "delete" button.

Record a macro while doing this then assign to a button from the Forms Toolbar
or drag one up to a toolbar from ToolsCustomizeCommandsMacros


Gord Dibben MS Excel MVP

On Wed, 1 Aug 2007 13:14:01 -0700, Dave wrote:

I need to find out how to put a button in excel that will clear all the
fields. Please help! :)