- Sep 3, 2013
I've written the code for a form which dynamically creates (and later removes) rows of text boxes. I now want either to print it or produce a pdf using vba - I don't want to use ALT-PRTSCR to copy and paste into another program. I would like a command button that does the trick. Previously, I've used:and this printed the underlying data tied to a worksheet. In this case, there is no single underlying sheet - the data is taken from various sheets and manipulated in memory. When I tried this earlier and used the Print Dialog command, Excel stopped working and just kept beeping at me. I've looked at other threads, such as:but before I get too deep, I would like to know if the experts here think this is possible, and if it is, what's the best way of tackling it?