option buttons or check boxes
 

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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200608/1

option buttons or check boxes
 

meandmyindigo via OfficeKB.com wrote:
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

option buttons or check boxes
 

Franz Verga wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200608/1