PilotNinja
New Member
- Joined
- Mar 24, 2015
- Messages
- 5
Hi everyone,
I come hat in hand again asking for help.
I am trying to incorporate some radio buttons and a print button into an excel worksheet. Ideally, the user would be able to click a radio button which would select a range of cells which the print button would then print.
For example, select the first radio button, lets call it "Shipping Label" then clicking print, would cause a group of cells containing all the info for a shipping label to print. The second label, lets call it "Return Address Label" would then print another set of cells containing the return address information.
I've linked radio buttons to cells and can make the linked cells return a value of either TRUE or FALSE, or different text, but I can't seem to figure out how to link that to what I want to print. Currently I have a print button for every of the 14 print options I need, but some radio buttons would really clean it up for me.
Any help would once again be greatly appreciated!
Thanks in advance.
I come hat in hand again asking for help.
I am trying to incorporate some radio buttons and a print button into an excel worksheet. Ideally, the user would be able to click a radio button which would select a range of cells which the print button would then print.
For example, select the first radio button, lets call it "Shipping Label" then clicking print, would cause a group of cells containing all the info for a shipping label to print. The second label, lets call it "Return Address Label" would then print another set of cells containing the return address information.
I've linked radio buttons to cells and can make the linked cells return a value of either TRUE or FALSE, or different text, but I can't seem to figure out how to link that to what I want to print. Currently I have a print button for every of the 14 print options I need, but some radio buttons would really clean it up for me.
Any help would once again be greatly appreciated!
Thanks in advance.