option buttons or check boxes

[meandmyindigo via OfficeKB.com]

I am fairly new to VBA and trying to learn on the fly. I have a spreadsheet
with 4 sheets, each with its own name. I want to create 4 check boxes or
option buttons on the first sheet. I have print button. I want to have it
so when you check a box and hit the print button, only that sheet will print.
If you check all 4, all 4 print, etc.

Can anyone help?

Thanks!

 

[Franz Verga]

I am fairly new to VBA and trying to learn on the fly. I have a
spreadsheet with 4 sheets, each with its own name. I want to create
4 check boxes or option buttons on the first sheet. I have print
button. I want to have it so when you check a box and hit the print
button, only that sheet will print. If you check all 4, all 4 print,
etc.

Can anyone help?

Thanks!

Maybe this suggestion from John Walkenbach's site would be useful for you:

http://www.j-walk.com/ss/excel/tips/tip48.htm

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[meandmyindigo via OfficeKB.com]

I am fairly new to VBA and trying to learn on the fly. I have a
spreadsheet with 4 sheets, each with its own name. I want to create

[quoted text clipped - 6 lines]

Thanks!

Maybe this suggestion from John Walkenbach's site would be useful for you:

http://www.j-walk.com/ss/excel/tips/tip48.htm

Thank you. I will check it out.