Using a macro to make selection in a drop down menu
 

Help!

-----Original Message-----
Hi everyone,

I'm trying to record a macro to print off all my sales
reports. When i record the macro it doesn't record the
part where i make a selection from my drop-down. So it
ends up looking like this....

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True

Which just ends up printing out the same page a bunch of
times. Does anyone know how i can tell excel in the
macro
how to make a selection in a drop down?

Thanks for any help!

- RJ
.

Using a macro to make selection in a drop down menu
 

What kind of dropdown

A dropdown from the forms toolbar
A combobox from the Control Toolbox Toolbar
Using Data Validation using the list option

what version of Excel must this work on?

--
Regards,
Tom Ogilvy

"Ryan Graf" wrote in message
...
Help!

-----Original Message-----
Hi everyone,

I'm trying to record a macro to print off all my sales
reports. When i record the macro it doesn't record the
part where i make a selection from my drop-down. So it
ends up looking like this....

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1,
Copies:=2, Collate _
:=True

Which just ends up printing out the same page a bunch of
times. Does anyone know how i can tell excel in the
macro
how to make a selection in a drop down?

Thanks for any help!

- RJ
.