Export chart as image - Input filename

Hi guys,

I've spent a bit of time searching this but have only been able to find bits and pieces of what I'm after. I want to add a button in my worksheet to export a chart as an image file, and have a msgbox prompt the user for a filename.

I would also like for the user to be able to browse for the file destination (without having to type the destination in full) but this may be asking a bit much...

Note: I'm relatively new to VBA so want to keep it as simple as possible.

Thanks in advance!

That is absolutely perfect.

Thanks for the quick reply!