PC Review


Reply
Thread Tools Rate Thread

Dialogsheet Checkbox to Select All Checkboxes

 
 
Swami
Guest
Posts: n/a
 
      9th Apr 2010
I am using a dialogsheet to get user input. The dialogsheet is created at
runtime. The amount of checkboxes on the dialogsheet varies based on how many
tabs are hidden. I would like to have a checkbox on the dialogsheet that
allows users to "select all" checkboxes.

Code Example:
Dim SheetCount As Integer
Dim CurrentSheet As Worksheet
Dim PrintDlg As DialogSheet
Dim cb As CheckBox

Set CurrentSheet = ActiveSheet
Set PrintDlg = ActiveWorkbook.DialogSheets.Add

'some code used to loop and build checkboxes not shown here

If SheetCount <> 0 Then
If PrintDlg.Show Then
For Each cb In PrintDlg.CheckBoxes
If cb.Value = xlOn Then
Worksheets(cb.Caption).Visible = True
End If
Next cb
End If
Else
MsgBox "There are no hidden worksheets!"
End If
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select checkboxes to select which pages to print ak_edm Microsoft Word Document Management 1 4th Feb 2010 11:04 PM
CheckBox to tick other CheckBoxes Michelle Microsoft Excel Programming 5 27th Oct 2009 02:38 PM
Checkbox checked then show more checkboxes Sara Microsoft Excel New Users 3 10th Sep 2008 07:16 PM
checkbox dilemma- need larger checkboxes =?Utf-8?B?TG9ib05ldHdvcms=?= Microsoft Excel Programming 1 2nd Dec 2004 03:31 PM
How to allow only one checkbox to be checked in a group of checkboxes moondaddy Microsoft ASP .NET 4 22nd Jun 2004 05:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:01 AM.