Creating Check Box in Excel VBA

Say, Please give detailed steps for the above in Excel 2013.
How can I test the state of the check box using VBA code?
How can I ensure that the last state is recalled when opening excel?
Tx

shaunwingin

Asked: 2014-04-24

Advertise Here

1 Solution

LVL 55

Rgonzo1971Commented: 2014-04-25

Hi,

You could insert form the Developer's tab / Controls / Insert / Form Controls a checkbox

and use this code

Sub Macro()
'
'True = 1 and False = -4146

Result = ActiveSheet.Shapes("Check Box 1").OLEFormat.Object.Value
End Sub

Open in new window

Regards

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 Already a member? Login.

Featured Post

Tackle projects and never again get stuck behind a technical roadblock.

Join Now

Expand your skills with this month's free Premium course.

Creating Check Box in Excel VBA

Join & Write a Comment Already a member? Login.