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! :)
Click to expand...

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! :)
Click to expand...

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