View Single Post
  #2   Report Post  
Naz
 
Posts: n/a
Default

1) Record yourself clearing the cells, as follows
Tools
Macro
Record New Macro
Select the cells
Press delete
Stop recording the macro.

2) Create button as follows
View
Toolbars
Form
From the forms bar select the button icon
Drag out a rectangular button
Once you have dragged it out a pop up will appear asking you to assign
a macro.
Select the macro you recorded in step 1)

Finished.
Any probs. Post back


--

_______________________
Naz,
London


"tamato43" wrote:

Hello,

Can anyone help me set up a button and macro to clear cells where data is
entered.

Lets say, I'm looking to clear Cells A1,B1,C1 and A3, B3, C3.

Remember I would still need a button that would then prompt the Macro.