Solved Check Boxes and Macros

February 11, 2014 at 00:57:25
Specs: Microsoft XP
I want to create a check box wherby when it is ticked it opens another sheet but if I untick it does nothing.

See More: Check Boxes and Macros

Report •

February 12, 2014 at 02:16:02
✔ Best Answer
I guess you are refering to MS Excel?

Add a Checkbox whereever you want then add the following code, you may need to modify it slightly to fit your requirements

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
ActiveWorkbook.Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "New Sheet"
End If
End Sub

Report •

February 12, 2014 at 04:38:51
Thanks yes sorry I was referring to Excel. I was in a hurry typing my question. I'l give this a go.

Report •

Related Solutions

Ask Question