<< How to run a batch file at a specific time | What is Scrum? >>

3/7/2010Working with excel vba check boxes

I have created a check box on a spread sheet and then named it AU from "Check Box 1". If I have selected AU checkbox then I am executing a command

If ActiveSheet.Shapes("AU").OLEFormat.Object > 0 Then
execute the command
End If

Submitted by Pavandeep Puddupakkam

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Posted by: wiki
Posted on: 3/7/2010 at 4:26 PM
Tags: excel macros, vba, check boxes, oleformat
Categories: VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (0) | Post RSS RSS comment feed

RSS comment feed

Related posts

How to extract the first 100 characters from a excel cell using vbaSay Call A1 has the value In this example I will tell you how you can extract the first 100 characte...Using Excel VBA Trim function with xpath in seleniumThe text in the excel cell had a space at the end of the string and this was causing the scripts to ...Change date format to australian data format with excel macro VBA.In this example I will tell you how you can change the date format to Australian data format (DD-MMM...

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added