Printing a form with a drop down list

[nickATnite]

I have a form that has a drop down list of different equipment numbers. Is
there a way I can print the form with it automatically putting in the next
number without having to go to the list, change to the next number and hit
print 50 times?

 

[Dave Peterson]

It would depend on how you made that dropdown.

If you used data|validation and a range for the list, you could loop through the
cells in that list.

If you used a dropdown from the Forms toolbar, you could loop through a range or
the elements in that list.

And same thing for a combobox from the control toolbox toolbar.

The code would be different for each of these.

So you'll have to share how you created the dropdown, where the cell is (if it's
data|validation) or the name of the dropdown or name of the combobox--and the
location of that range used for the list (if there is one).

And you may want to share the address of the print range for that sheet--unless
the entire sheet should be printed.

 

[nickATnite]

I used the data l validation option. The cell is on the top of the form.
E4-I4. Location of the range is A97-A153. Print range is A1-L32. I hope
this is the right info you were asking about.