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
.
|