IF statements and Macros

[rmcbreen]

I am not sure that this is possible, but I want to write an if statemnet that will run a macro to print a page if a certain box is checked.

Example: If a box is checked to run a certain test, I want an IF statement that recognizes that the box is checked, and will print the test pages(seperate workbook) when I print the worksheet with the checked box.

Any ideas?

Actually, I am not sure that I would need to use IF statements, if there is a way to do this without IF's, that would be great too.

Thanks

Ryan
This message was edited by rmcbreen on 2002-10-23 18:09

 

[Joe4]

Right click on your check box, click on "Assign Macros" and click on "New". Then in the VBA editor, enter the following code

Sub CheckBox1_Click()

If ActiveSheet.CheckBoxes(Application.Caller).Value = xlOn Then
'(enter code here for printing worksheet)
End If

End Sub

If you do not know VBA well, you can turn on the macro recorder, open the workbook you want to print, print, and then stop the recorder. Then in VBA editor, copy the code you just recorded into the macro above.

Hope this helps.

 

[rmcbreen]

Thanks for the help, I think I can get it to work now.

Ryan

 

[majtnet]

Bump: Macro If statements

I got the if statement, what do you put next to skip to next statement when the first criteria isn't met?