VBA change form control and print first page as .pdf

JoaoGabriel

New Member
Joined
Jun 6, 2021
Messages
14
Office Version
  1. 2019
Platform
  1. Windows
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?
1633974980605.png

Can anyone hep? Thank you very much in advance
 

SQUIDD

Well-known Member
Joined
Jan 2, 2009
Messages
1,936
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,148,022
Messages
5,744,368
Members
423,865
Latest member
SimSum

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top