Solved

Creating Check Box in Excel VBA

Posted on 2014-04-24

1 solution

Medium Priority

488 Views

Last Modified: 2014-04-25

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

Comment

Question by:shaunwingin

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

1 Comment

LVL 52

Accepted Solution

by:Rgonzo1971

Rgonzo1971 earned 1500 total points

ID: 400219582014-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

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ensure Data Integrity and Privacy with VBA

Article by: Josh

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.

A Game of Draw Poker

Article by: Martin

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.

Creating a Scrolling Table in Excel

Video by: AnnieCushing

This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

Microsoft Excel

Using, Creating and Modifying Styles in Microsoft Excel

Video by: Bob

Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…