I need help to get the state (xlon or xloff) of check boxes on a worksheet.
i have tried the following but unable to get it to work.
Any solutions would be much apprecaited
please see sample workbook attached.
Sub showvalue() Dim myshape As Shape For Each myshape In ActiveSheet.Shapes If myshape.Value = xlOn Then ' do what i want here MsgBox myshape.Name & " is on" End If Next End Sub
Bookmarks