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.

What does all this mean. What "print macro"

--
Regards,
Tom Ogilvy


"LT" wrote:

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.

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" wrote:

What does all this mean. What "print macro"

--
Regards,
Tom Ogilvy


"LT" wrote:

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.

Sub MyPrintMacro()
Activesheet.Printout
End Sub

or

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

--
Regards,
Tom Ogilvy


"LT" wrote in message
...
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" wrote:

What does all this mean. What "print macro"

--
Regards,
Tom Ogilvy


"LT" wrote:

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.