userform export as pdf with textbox filename

[sureshtrb]

for worksheet to pdf print

[COLOR=#333333]ActiveSheet.ExportAsFixedFormat[/COLOR]

and what is the code for userform to exportas fixed format?

 

[sureshtrb]

Any Help!

 

[mohan.pandey87]

you can not save user form seperately as PDF as it is a part of excel and you can only see it once you run macro. So if you export as PDF then the excel file will save as PDF not the userform seperately.

HTH

 

[sureshtrb]

Thanks for youradvcie.
My intention is not to save userform as it is with data.
I want to print it as pdf when I press print button with selecting file name automatically by taking the value of 2 textboxes i have entered in that userform., same like printing the worksheet data

 

[sureshtrb]

Any Update?

 

[sureshtrb]

Help!