Clear Command Button

**tapsmiled** · 02-27-2014, 09:19 PM

I want to add a button to a sheet that, when clicked, will clear the values from Cells A5:A26. Can anyone assist?

**tapsmiled** · 02-27-2014, 09:31 PM

Found it...

Private Sub CommandButton1_Click()
Dim resp

resp = MsgBox("Are you sure?", vbOKCancel)
If resp = vbOK Then
    ActiveSheet.Range("A1").Value = Null
End If
End Sub

Google rocks

**ajryan88** · 02-27-2014, 09:32 PM

Hi,

Like this???

**alansidman** · 02-27-2014, 09:33 PM

Try this:

Sub foo()
Dim rng As Range
Set rng = Range("A5:A26")
rng.ClearContents
End Sub

Clear Command Button

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Clear Command Button

Re: Clear Command Button

Re: Clear Command Button

Re: Clear Command Button

Thread Information

Users Browsing this Thread

Similar Threads

Clear command button

Command Button - Clear

Command Button to clear checkbox

Command Button To Save & Clear

[SOLVED] How do i clear a cell using a command button?

Bookmarks

Bookmarks

Posting Permissions