Command Button

[sprigelz]

Good day,

I am looking to get a button to press that will cycle through a dropdown list and print. For example, on Sheet "Hourly" I have a print area set. The dropdown is in J2. There are roughly 50 items in the dropdown.

I want the button to be able to go through each listed item in the dropdown and print off the results from the Print area. The Print area is all formulated to change when the dropdown selection is changed.

Example;
Dropdown List - 21,40,75,82

I want it to cycle through and do the following;
21,print,40,print,75,print,82,print

Is this possible?

 

[AlphaFrog]

Re: Command Button Help

How is the dropdown list populated? Is there a reference to a Range of cells that has the list?

 

[sprigelz]

Re: Command Button Help

It is a defined name from a Pivot Table

 

[DanteAmor]

Re: Command Button Help

Run this macro on the sheet that contains the dropdown list

Sub Macro1()
    Dim r As Range
    For Each r In Range(Range("J2").Validation.Formula1)
        Range("J2").Value = r.Value
        Sheets("Hourly").PrintOut
    Next
End Sub

 

[sprigelz]

Re: Command Button Help

I will try this first thing on Monday. Thank you!!

 

[sprigelz]

Re: Command Button Help

Macro works perfectly.

 

[DanteAmor]

Re: Command Button Help

Macro works perfectly.

I'm glad to help you. Thanks for the feedback.