Print Marco with a Combo Box

[Guest]

How do I use the print macro with a combo box? I can get the macro to run,
but it wont change the combo box to reflect a new selection.

 

[Guest]

What does all this mean. What "print macro"

 

[Guest]

I'm creating a macro that will print a report. The macro is assigned to a
text box. The report has a combo box with a list of different parameters
that will feed the report depending on what you choose. I'm trying to create
a macro that will print when the text box is selected. So, I'm trying to
create a print macro that will work with a combo box.

 

[Tom Ogilvy]

Sub MyPrintMacro()
Activesheet.Printout
End Sub

or

Sub MyPrintMacro()
Range(Activesheet.Combobox1.Value).Printout
End Sub