Groups > microsoft.public.excel.programming > #109011 > unrolled thread

Clear Contents and Checkboxes Button

Started by	chrisparker3268 <chrisparker3268.11af2578@excelbanter.com>
First post	2016-06-21 17:44 +0100
Last post	2016-06-21 18:59 +0200
Articles	2 — 2 participants

Back to article view | Back to microsoft.public.excel.programming

  Clear Contents and Checkboxes Button chrisparker3268 <chrisparker3268.11af2578@excelbanter.com> - 2016-06-21 17:44 +0100
    Re: Clear Contents and Checkboxes Button Claus Busch <claus_busch@t-online.de> - 2016-06-21 18:59 +0200

#109011 — Clear Contents and Checkboxes Button

From	chrisparker3268 <chrisparker3268.11af2578@excelbanter.com>
Date	2016-06-21 17:44 +0100
Subject	Clear Contents and Checkboxes Button
Message-ID	<chrisparker3268.11af2578@excelbanter.com>

Hello,

I am trying to create a button in that will clear contents of E5:E8 and
and also clear all checkboxes (located in D5:D8) on the sheet. I have
the codes below but can't seem to get them to work together.
Additionally, I cannot recall whether I created the checkboxes with
activex or form.

Private Sub CommandButton1_Click()
Range("E5:E8").ClearContents
Sub clearcheck()
ActiveSheet.CheckBoxes.Value = False
End Sub




-- 
chrisparker3268

[toc] | [next] | [standalone]

#109012

From	Claus Busch <claus_busch@t-online.de>
Date	2016-06-21 18:59 +0200
Message-ID	<nkbrp2$ldr$1@dont-email.me>
In reply to	#109011

Hi Chris,

Am Tue, 21 Jun 2016 17:44:16 +0100 schrieb chrisparker3268:

> I am trying to create a button in that will clear contents of E5:E8 and
> and also clear all checkboxes (located in D5:D8) on the sheet. I have
> the codes below but can't seem to get them to work together.
> Additionally, I cannot recall whether I created the checkboxes with
> activex or form.

your checkboxes have refer to column T range T5:T8.
Try:

Sub Test()
Range("E5:E8").ClearContents
Range("T5:T8") = False
End Sub


Regards
Claus B.
-- 
Windows10
Office 2016

[toc] | [prev] | [standalone]

csiph-web