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...
Make the drop-down a multi-select list and loop through the selection.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Oh, man, I can do the multiple select, but can't do the loopy loop thing...Originally Posted by xld
Show us you your multi-select enhanced code.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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...
What sort of listbox, ActiveX or Forms, or even Userform?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
