PDA

View Full Version : Print Multiple Pages from DropDown Box using Macros?



klutz
11-08-2009, 06:03 PM
Hola to everyone,

I have an excel file in which there is drop-down box that can contain up to 30 country names.

When I manually choose a country a host of data is populated on the excel template. I then click on a print command button and it print the complete template with the country data.

If I have 3 country the task is easy. But when I have 30 countries I have to do this to each one individually.

Is there a way thru VBA that a macro can do this?

The Klutz...:beerchug:

Bob Phillips
11-09-2009, 01:29 AM
Make the drop-down a multi-select list and loop through the selection.

klutz
11-09-2009, 06:14 AM
Make the drop-down a multi-select list and loop through the selection.

Oh, man, I can do the multiple select, but can't do the loopy loop thing...:help

Bob Phillips
11-09-2009, 06:37 AM
Show us you your multi-select enhanced code.

klutz
11-09-2009, 07:04 AM
Show us you your multi-select enhanced code.

Lost in space,

What I do have is I changed the drop-down to list box cuz drop-down don't have mutli-select in excel, at least I did not find anything that can change it.

I can't even begin to fathom the code for this...:wot

Bob Phillips
11-09-2009, 07:57 AM
What sort of listbox, ActiveX or Forms, or even Userform?