option buttons or check boxes

  • Thread starter Thread starter meandmyindigo via OfficeKB.com
  • Start date Start date
M

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!
 
meandmyindigo said:
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!
Click to expand...


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
 
Back
Top