View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KLZA KLZA is offline
external usenet poster
 
Posts: 64
Default 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!!!