• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 42
  • Last Modified:

Macro help for checking and unchecking cells

EE Pros,

I have a graphic that allows someone to select a specific condition for displaying a row or column of data.  

Doubleclick and the check appears; Doubleclick again and it SHOULD disappear.  There are 7 vertical check boxes (cells) and 4 horizontal check boxes (Cells).  What currently works is if you delete the existing check boxes (vertical), and doubleclick, you will see the checkmarks appear.  Doubleclick, they do not disappear (not working).  And none of the horizontal check boxes/cells work yet.

Talk a look (instruction is in yellow).

Thank you in advance!

B.
RadarChartMultiVariable.xlsm
0
Bright01
Asked:
Bright01
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
Change the top part as shown.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Provides check button

If Target.Column = 4 Then
'If Target = Chkboxvertical Then

Open in new window

0
 
Martin LissOlder than dirtCommented:
This gets the horizontal ones too

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim rng As Range
Set rng = Union(Range("D6:D12"), Range("F4:I4"))
If Not Intersect(Target, rng) Is Nothing Then
    Application.ScreenUpdating = True
    With ActiveCell

Open in new window

0
 
Bright01Author Commented:
Works!!!!  Great.  Appreciate the fix.  And I must say, I'm doing much better in reading your responses..... which may mean, I've actually begun to learn something!

Thanks again.

B.
0
 
Martin LissOlder than dirtCommented:
Your welcome and if there's anything in one of my answers that you don't understand then please ask.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now