| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list - how doo I make selection disapear? | Excel Discussion (Misc queries) | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| how to make a menu selection in the same cell? | Excel Discussion (Misc queries) | |||
| Hiding a cell's drop-down menu, dependent on a tick-box selection... | Excel Discussion (Misc queries) | |||
| need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
Linear Mode
