Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
I am looking for a Macro. I am trying to have a button on my spreadsheet that
when clicked will clear data in specific cells. For instance, a button when clicked will clear data from cells A1, B77 and S66. By the way, I don't know how to make the button either. -- bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
there are two methods. One where you put the button on the worksheet and the
second where you put the button on the top of the worksheet in a tool bar. Here is how to put the button on the worksheet 1) Excel Menu View - toolbats - Control toolbox 2) Press the rectangular button on the toolbar. Then press on the worksheet where you want the button to be located. You can resize the button. right click the button and change CAPTION which is the words that appear on the button 3) Double click on button and a macro window will appear with two lines of code. change this code to look like the following. Don't change the button number. each button on the worksheet will have aq unique button number which is the name of the button that appears in the property of the button. If you change the name property of the button then the macro name has to be the same. Private Sub CommandButton1_Click() Range("A1").ClearContents Range("B77").ClearContents Range("S66").ClearContents End Sub "vdmbqb" wrote: I am looking for a Macro. I am trying to have a button on my spreadsheet that when clicked will clear data in specific cells. For instance, a button when clicked will clear data from cells A1, B77 and S66. By the way, I don't know how to make the button either. -- bob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
Or a bit neater, Range("A1,B77,S66").ClearContents :-) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
Joel,
Thank you-this works perfectly. Just one question, is there a way to write the same code in a range. For instance; clear cells A1 thru A209. Thanks again -- bob "Joel" wrote: there are two methods. One where you put the button on the worksheet and the second where you put the button on the top of the worksheet in a tool bar. Here is how to put the button on the worksheet 1) Excel Menu View - toolbats - Control toolbox 2) Press the rectangular button on the toolbar. Then press on the worksheet where you want the button to be located. You can resize the button. right click the button and change CAPTION which is the words that appear on the button 3) Double click on button and a macro window will appear with two lines of code. change this code to look like the following. Don't change the button number. each button on the worksheet will have aq unique button number which is the name of the button that appears in the property of the button. If you change the name property of the button then the macro name has to be the same. Private Sub CommandButton1_Click() Range("A1").ClearContents Range("B77").ClearContents Range("S66").ClearContents End Sub "vdmbqb" wrote: I am looking for a Macro. I am trying to have a button on my spreadsheet that when clicked will clear data in specific cells. For instance, a button when clicked will clear data from cells A1, B77 and S66. By the way, I don't know how to make the button either. -- bob |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
Range("A1:A209").ClearContents Or incorporated with your earlier ones: Range("A1:A209,B77,S66").ClearContents |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear button
Thank you-you guys are great!!
-- bob "dimm" wrote: Range("A1:A209").ClearContents Or incorporated with your earlier ones: Range("A1:A209,B77,S66").ClearContents |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel clear button | Excel Worksheet Functions | |||
clear button | Excel Discussion (Misc queries) | |||
Clear Cells Button | Excel Discussion (Misc queries) | |||
Clear Button | Excel Discussion (Misc queries) | |||
Button to clear all entries? | Excel Worksheet Functions |