BatchPrinting

[lighting77]

I have a excel form with a drop down menu containing product codes that populates other cells within the form when each unique product code is selected. I like to print all forms, each form having its unique product code and it’s relevant populated cells.
How can I print all of these at ones without selecting each product code and than hitting print. Could anyone help, please. Thanks

 

[traveler4]

A macro could iterate over all the drop down menu's items.

When you say "excel form", do you really mean
A) a VBA Userform or
B) rather an Excel worksheet
?

 

[lighting77]

A macro could iterate over all the drop down menu's items.

When you say "excel form", do you really mean
A) a VBA Userform or
B) rather an Excel worksheet
?

An excel worksheet

 

[traveler4]

Right-click on the Dropdown element and in the context menu select Format control (or whatever it is called in your language). In the second box of the dialog's last tab (Control) you can determine a cell which will be linked to the the current selection in the dropbox. If the first element of the dropbox is selected, the cell will show 1, if the 2nd element is selected, the cell shows 2 and so on.
The link is bidrectional: if you enter 1 into the cell, the dropbox will show the first entry, if you enter 2 into the cell, ....

So a macro can enter 1, 2, 3, ... into the cell, the dropdown element shows the 1st, 2nd, 3rd, ... entry and (as if the user had changed the dropdown element) the other cells are populated accordingly.
Add a print command (PrintOut) to the macro and done.

A working example is here. This is the code included:

Option Explicit

Sub print_all()
    Dim dd As DropDown
    Dim i As Integer
    
    With ActiveSheet
        Set dd = .DropDowns(1)
        For i = 1 To .Range(dd.ListFillRange).Cells.Count
            .Range(dd.LinkedCell).Value = i
            
            .PrintOut
        Next
    End With
End Sub