VBA change form control and print first page as .pdf

[JoaoGabriel]

How can i make a button or a macro who change the form control to print each city in its range and save the first page in red as .pdf with the name of the city selected by the form control?

Can anyone hep? Thank you very much in advance

 

[SQUIDD]

Ok glad you got it working.

Im not sure how to interact with a form control dropdown to be honest.

Regarding the directory, i dont think it will create the directory, however, you can write code to check if the directory exists, then create it if it does not.

Is that something you are wanting to add.

What was your final code that worked for you?