How to print all list in my drop down list menu? (please give me step by step)

[fulky]

example2.xlsx

I have attached my form excel.
If you open this file you can see in the top there is a drop list menu.
There is so many lists that i have to print in the menu.
I have to click one by one in drop list menu and then print it one by one.
I ask How to print all list in my drop down list menu?
Please give me step by step, because i'am a really newbie about macro.
I hope you can solve my problem.

Thank you all...

[martindwilson]

there is nothing in the menu!

[fulky]

example2 new.xlsx

I'm sorry. I have updated the new file.
I seek for your help.
Thank you

[fulky]

there is nothing in the menu!

I'm sorry. I have updated the new file at above.
I seek for your help.
Thank you

[oeldere]

It looks like (to me) there has to be a list of this data.

But I don't see them in the your file (or VBA).

In that case you could print the list instead of the dropdownbox.

I don't see hidden sheets in you file.

This one goes is for another member.

[fulky]

It looks like (to me) there has to be a list of this data.

But I don't see them in the your file (or VBA).

In that case you could print the list instead of the dropdownbox.

I don't see hidden sheets in you file.

This one goes is for another member.

i have updated the file in post #3

[oeldere]

Yes I've seen your file (in #3), but don't see the option in it (which in posted in #5).

[martindwilson]

list is in l3: l20 of tabel 1 its a combo box from the forms control

[fulky]

Yes I've seen your file (in #3), but don't see the option in it (which in posted in #5).

in my file, my menu have CELL LINK in column row AH2
and have INPUT RANGE in sheet 'Tabel I'!L3:L20
maybe you can imagine it.

[oeldere]

@Martindwilson.

Thanks for pointing the right direction (L3:L30).

@fulky

copy column L of sheet tabel 1 to anther sheet.

use delete duplicated

and after that you're able to print your list.

[fulky]

list is in l3: l20 of tabel 1 its a combo box from the forms control

yes, so can you help me to solve my problem?
so, i dont have to click the list at the box one by one, and print it one by one too

[oeldere]

See for an solution #10

[martindwilson]

i think op wants to print the front page with every option chosen so 17 front pages print a bit of code looping through print then step to next print and so on

[fulky]

@Martindwilson.

Thanks for pointing the right direction (L3:L30).

@fulky

copy column L of sheet tabel 1 to anther sheet.

use delete duplicated

and after that you're able to print your list.

sorry, maybe there is a misunderstand.
what i mean is i have to print all form in sheet TVF based on the list.
but what im doing now i print the form based on the list one by one.
so, i seek for the formula that can print all the form based on the list by one click.

[MarvinP]

Hi Fulky,

You need to create a macro like the below and simply run the macro to print all 17 of dropdown imputs....

Run the Macro called PrintAllofL while looking at the TVF sheet.

Please Login or Register  to view this content.

Hope that helps.

[fulky]

Hi Fulky,

You need to create a macro like the below and simply run the macro to print all 17 of dropdown imputs....

Run the Macro called PrintAllofL while looking at the TVF sheet.

Please Login or Register  to view this content.

Hope that helps.

Thank You Marvin, You save my day. :D
Marvin, can i ask you for help again?
I have a form that i hope you can help me to create macro like before.
This is the file --> pvf form 1.xlsx
By the way in this file, the data will be increase day by day and i don't have to print it all day by day.
Let say, someday i have to print the form (PVF) from Table sheet only row 20-50, the next day i have to print only row 50-55, and the next day only row 56-77
Could you create a macro like that?

[oeldere]

You want to print the rows on Table Sheets.

You need e.g. row 50 - 55 or you mean no 50 - 55.

You have to tell us why you need the those rows (what are the similarity ow those rows?)

[fulky]

You want to print the rows on Table Sheets.

You need e.g. row 50 - 55 or you mean no 50 - 55.

You have to tell us why you need the those rows (what are the similarity ow those rows?)

in Table Sheet there have a synchronization formula to form in PVF Sheet.
so the "Row" in Table Sheet will be change the "Form" in PVF Sheet.
so, i need the flexible macro that can choose which "row to row" that i have to print.

[oeldere]

I can't help you enough wiht this question.

But I also have to say that it's not clear to me, what you wanna do (achieve).

Maybe another member could help you.

[muoixd]

Hi,
This is great code but i don't know why it can't work on my file. The dropdowns seem not work.
Pls kindly advise

[scottiex]

Don't post your questions in other peoples threads - they don't like you reincarnating ancient threads here.
Instead please create your own thread and reference this one if it is appropriate.

FWIW I imagine it is something like that you haven't adjusted the drop down box name to match the code (or similar required adjustments).