Posts by HeathAN

    [SOLVED] Re: print a page on checkbox value

    Hi Guys,

    I'm a complete novice when it comes to VBA, so I need some help.

    I am trying to work out how to set up a macro (or VBA) in order to print a page and then pull information form the next row down, rinse and repeat.

    The first worksheet I have is for data entry (called Enter Discounts) this has a list that must be manually entered. Also next to each line is a checkbox so I can select whether to print it or not. So I need some thing to check the TRUE/FALSE value, update another worksheet called Ticket with the name from the first worksheet, then print out that worksheet only if the value is TRUE (ie checkbox selected).

    Then it needs to go to the next line and do the same thing.

    Any help would be greatly appreciated.

    Also posted:…292796#post292796</a><br>


    Welcome to OZ Grid
    Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum.

    The title has been change but please comply in the future