Results 1 to 3 of 3

Build sheet array from checkboxes?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Build sheet array from checkboxes?

    I have a user form with checkboxes, one for each sheet in the workbook. The user selects the appropriate checkboxes then clicks a command button that prints selected sheets.

    How do I build the array so it holds only the selected sheets?

    I'm using this to print the sheets:
    Sheets(Array(sh1, sh2, sh3)).Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    sh1, sh2 hold the sheet names:
    If CheckBox1.Value = True Then
    sh1 = "Control Panel"
    End If
    I hope this is enough information, thanks for helping me.

    Excel 2000
    Last edited by proepert; 03-28-2010 at 09:08 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1