| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a "CLEAR" button to the worksheet
On my worksheet I would like to add a"CLEAR" button that would delete the
contents of multiple cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a "CLEAR" button to the worksheet
Go to View/Toolbars/Control Toolbox/Click on the command button icon and place on the sheet. Right click the button and place this code into it (Change the cell reference to the cells you want to affect). Then change the range to suit. Code: -------------------- Sheets("sheet1").Activate Range("a2,d2,f2,h2").Select Selection.ClearContents -------------------- Come out of design view and test. Make sure to test this on a copy. Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=499182 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Worksheet To Formula | Excel Worksheet Functions | |||
| Adding columns to a worksheet | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| adding a command button to an excel cell? | Excel Discussion (Misc queries) | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Linear Mode
