+ Reply to Thread
Results 1 to 8 of 8

Check box to print and export

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    367

    Check box to print and export

    Hi,
    this is a repost of my post here https://www.excelforum.com/excel-pro...tml?highlight=

    I duno the title cannot end with Print. =(

    hope someone can shine some light here. Refer attached. i need a macro where user can click on the checkbox (Column E which i put in Red fill). Then click either on Export button or Print button. Export button will CUT and Paste it to Export tab while if they click Print, it will print the voucher tab. The voucher tab currently is using vlookup to a cell in cell F1. So i hope that its possible if someone tick on S/N 1 and S/N 3 and Print, the macro shd "change the value in cell F1 to 1 n print, then repeat the process for 3"

    Also, i hope to have a insert function where user can Add line (with the checkbox as well)

    Thanks. Hope its not too demanding....=)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Check box to print and export

    Hi JP,

    In your sheet, change the font in cells E3:E5000 to Marlett Font and add the following code to your Data sheet module.

    Please Login or Register  to view this content.
    Assign the macros to the appropraite buttons.

    When the user clicks a cell in column E, a checkmark is toggled on/off. Select the rows you want the action to occur then click a button:
    Export appends selected rows to the Export sheet
    Print prints the selected vouchers
    Add adds a line above each selected row.

    HTH,
    Maud
    Attached Files Attached Files
    Last edited by Maudibe; 03-09-2018 at 01:27 AM.

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    367

    Re: Check box to print and export

    Hi, when i click export, i mean the line are cut and paste to export tab. Not delete entirerow.

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    4,904

    Re: Check box to print and export

    Remove this line.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  5. #5
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    367

    Re: Check box to print and export

    Quote Originally Posted by bakerman2 View Post
    Remove this line.
    Please Login or Register  to view this content.
    Hi, but it didnt paste to the Export tab. How?

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    4,904

    Re: Check box to print and export

    Please Login or Register  to view this content.

  7. #7
    Valued Forum Contributor Maudibe's Avatar
    Join Date
    12-21-2016
    Location
    USA
    MS-Off Ver
    2010-2013
    Posts
    326

    Re: Check box to print and export

    Or

    Please Login or Register  to view this content.
    @Bakerman: Thank you for moving the NextRow=.....
    Attached Files Attached Files
    Last edited by Maudibe; 03-10-2018 at 12:57 AM.

  8. #8
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    367

    Re: Check box to print and export

    Hi, is there no way to do via Check Box?

+ Reply to Thread

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