LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default mulitple checkboxes - changing value of all of them at once

Hello,

I have mulitple checkbox controls (selected from the "control" toolbar) on
one worksheet. I would like to set the state of each checkbox to unchecked
all at once. I have figured out how to select all the checkboxes at one time
using:

ActiveSheet.OLEObjects.Select

But I cannot figure out how to change the value of all of them to "false".
I have tried, with no luck:

Selection.Value = false
Selection.oleobjects.Value = false
Selection.oleobjects.object.Value = false
etc
etc

Anyone how to do this?
Thanks.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mulitple value lookup kritter286 Excel Worksheet Functions 5 April 20th 09 10:16 PM
Changing mulitple tab names RD Excel Worksheet Functions 4 May 3rd 07 03:23 PM
Mulitple formulas Joey041 Excel Discussion (Misc queries) 1 November 16th 06 02:48 AM
mulitple criteria imjustme Excel Discussion (Misc queries) 9 September 2nd 05 02:07 AM
Changes to Mulitple Worksheets Mac Landers Excel Worksheet Functions 3 January 26th 05 12:59 AM


All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"