Thread: clear button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default clear button

View Toolbars Forms

click on the button icon and put a button on the worksheet. When the Assign
Macro dialog box appears, select new and enter:

Sub Button1_Click()
Range("F6:G22", "K6:K17").Clear
End Sub
--
Gary''s Student - gsnu200770


"YMC" wrote:

Is it possible to make a button clear certain cells. i want a button that
will clear F6:G22 and K6:K17
i am not to sure how to put together the code. could someone please give me
an example? thankyou