On my worksheet I would like to add a"CLEAR" button that would delete the
contents of multiple cells.
On my worksheet I would like to add a"CLEAR" button that would delete the
contents of multiple cells.
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 in the space between the private sub commandbutton1_() and End Sub(Change the cell reference to the cells you want to affect).
Come out of design view and test. Make sure to test this on a copy.Please Login or Register to view this content.
Larry
Last edited by keithl816; 01-08-2006 at 02:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks