| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation and a Clear Button
On Dec 31, 3:08*pm, Dave Peterson wrote:
And make sure you've allowed macros to run--you may need to change the security setting and/or answer the prompt when the workbook is opened. wrote: On Dec 31, 1:45 pm, Dave Peterson wrote: First, Cells.clearcontents will clear all the cells on the worksheet. *I'm not sure that's what you want! Second, you don't want the other stuff--just this: Private Sub CommandButton1_Click() * *me.range("a1,b3,d3,e9:f10").ClearContents End Sub Change that a1,b3,d3,e9:f10 stuff to just the addresses that should be cleared. wrote: On Dec 31, 12:25 pm, "Dan R." wrote: Open the control toolbox and add a command button to your worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why the data validation button is greyed out when it is in trackchange mode in Excel 2007 | Excel Discussion (Misc queries) | |||
| Create a Clear button to clear unprotected cells | Excel Programming | |||
| Data validation dependent of value of option button | Excel Programming | |||
| Userforms submit button to clear after it enters data? | Excel Programming | |||
| question data validation and delete/clear behavior | Excel Programming | |||
Threaded Mode
