Printing Macro for Combobox

[RAM]

Hi,

I'm looking for a macro for a Form Combobox that prints the sheet when a new date has been selected in the combobox.

Thanks in advance.

RAM

 

[BrianB]

If you doubleclick the combobox in design view then you get access to the Events for it (dropdown top right). Excel helpfully puts the Change one in the macro sheet - which I guess is the one you want.

The simple code is

ActiveSheet.Printout

 

[RAM]

Thanks Brian,

That would work if I have a combobox from Control Toolbox and I have it from Forms, but I took the same codes and right clicked on the combobox and pasted it in Assign Macro and it works!
[Edit] It doesn't allow me to change the Event though, but Change was automatically selected and every time I change the drop down selection (from the combobox) the sheet get printed out. I have a couple of hundreds of sheets to print out and this will come very handy.

Thanks!

RAM