I have design a dashboard like worksheet Tab. Here I have many fields ike dropdown, textbox and comment field. out of these only comment field is dynamic i.e. its size does change automatically as input goes.
I need a print functionality so that I could print this.
Can you please suggest how could I print this dynamic Tab using VBA.
Also require if print goes beyond one page because of long input comments I might require footer as well.
Looking forward to hearing from you.