Results 1 to 3 of 3

Thread: Print Nth Worksheet To Mth Worksheet using VBA

Threaded View

Ryan_Bernal Print Nth Worksheet To Mth... 02-26-2013, 05:30 PM
Ryan_Bernal Guys, I already solve my own... 02-28-2013, 11:14 AM
Excel Fox Thanks for posting Ryan 02-28-2013, 06:57 PM
Previous Post Previous Post   Next Post Next Post
  1. #1
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0

    Print Nth Worksheet To Mth Worksheet using VBA

    I want to create vba code that will print the specific Worksheet, From - To,No. of Copies.
    I have 3 textboxes and 1 combobox.
    1.txtFrom
    2.txtTo
    3.txtCopy
    4.cmbListForm

    My Combobox List Down the Forms.
    I've search code but i don't know how to execute this.
    Code:
    x= cmbListForm.List
    Worksheets("X").PrintOut Copies:=txtCopy.Value, from:txtFrom.Value, To:=txtTo.Value
    Here is my workbook.
    Attached Files Attached Files

Similar Threads

  1. Trim all Cells in a Worksheet - VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 08-21-2015, 08:22 AM
  2. Replies: 7
    Last Post: 05-17-2013, 10:38 PM
  3. Replies: 2
    Last Post: 01-29-2013, 02:45 PM
  4. Combobox VBA update value worksheet
    By Tony in forum Excel Help
    Replies: 4
    Last Post: 10-28-2012, 12:28 AM
  5. Sort Worksheet by Color VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 10-25-2011, 02:25 AM

Posting Permissions

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