Results 1 to 2 of 2

Dynamic Print Area with VBA

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2021
    Location
    Copenhagen,Denmark
    MS-Off Ver
    Office 365
    Posts
    9

    Exclamation Dynamic Print Area with VBA

    Hi all,

    I need help in VBA for a dynamic print area.

    Setting the premise

    This relates to an order form. I have 2 sheets: input and output

    Input sheet has checkboxes of 10 products and field to enter quantity.

    Output sheet has an invoice layout with descriptions of all 10 products (preset), prices (based on selected products) and quantity.


    My question...
    I want to write a VBA such that if product 1,4 ,9 (or any other sequence) is selected, the output sheet only shows that.

    The catch here is that, output sheet should be print ready in a set (professional) layout no matter the number of products selected .

    Anyone has an idea of how I can efficiently get the print area to change based on selections on input sheet and without having to write scripts for all possible outcomes?
    Last edited by Kebad; 09-29-2021 at 09:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-29-2019, 02:51 AM
  2. [SOLVED] Set print area for a dynamic range and launch print dialog
    By BONCH in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2017, 11:37 PM
  3. how to print using combobox and make dynamic range of a print area
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2014, 07:26 AM
  4. Code and Formula to print dynamic print area ranges
    By stpeter in forum Excel General
    Replies: 1
    Last Post: 10-15-2013, 03:33 PM
  5. Replies: 1
    Last Post: 09-05-2013, 03:32 AM
  6. [SOLVED] Need ‘Set Print Area’ Code for Dynamic Print Range based on Conditions
    By dosbirn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:13 PM
  7. Replies: 2
    Last Post: 01-04-2013, 04:22 PM

Tags for this Thread

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