MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro that selects from dropdown???

Posted by Travis on February 08, 2002 10:52 AM

Is there a way to make a macro select from a dropdown of a combo box on a control form?

For example... Select the first option in the drop down then print, then select the second option in the drop down then print, and repeat until the last option in the drop down has been selected and printed.

Trying to record it, doesnt record anyhting once the dropdown is selected.

Thanks in advance.

Posted by DMV on February 08, 2002 7:52 PM

Like this?

Selection.AutoFilter Field:=1,Criteria1:=Variable