is it possible 2 macros in 1 check box?

H

HERNAN

Hello everyone!
I know how to assigne a macro to a check box, but what I don't know is how
to go back to the previous situation (before the macro was run) when I
unclick it.

Thank you so much.

Another question: what I want to do is to create a more friendly user
interface for my data so people with no excel skills can work manipulating
the data in an easier way. So I created a pivot table and now I want to use
"check boxs" with macros (the macros selectes different situations on the
pivots.) my question is there any easier or better way for me to do this???
any ideas?? thank you!
 
R

Roger Govier

Hi

If you allocate a Linked cell to the checkbox, I used H1, then the following
approach will work

Private Sub CheckBox1_Click()
If Range("H1") Then
MsgBox ("Hello")
Else
MsgBox ("Goodbye")
End If
End Sub

Also take a look at Debra Dalgleish's site for help on using dropdown Data
validation boxes off the PT to change settings on the PT itself, and for
making the same changes to multiple PT's from one selection.
http://www.contextures.com/excelfiles.html#Pivot
and in particular
http://www.contextures.com/PivotMultiPagesCellChange.zip
http://www.contextures.com/PivotMultiPagesChangeAll.zip
 
Top