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

D

Dave

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

KLZA

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!!!
 
K

KLZA

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!!!
 
G

Gord Dibben

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 Tools>Customize>Commands>Macros


Gord Dibben MS Excel MVP
 
Top