Using Option Buttons with Printing Function

[Scottie in BKK]

Guys,

I'm still a green thumb at VBA's however you guys have been able to help me 9 times out of 10.

I am trying to make a printing function, I have 3 option buttons & a command button. What I would like to do is click one of the 3 option buttons then click the command button to print out the sheets as detailed in the code I have so far as below.

Can anyone assist?

Please Login or Register  to view this content.

[Norie]

All you appear to be missing are End Ifs.

Please Login or Register  to view this content.

[Scottie in BKK]

Hi Norie,

I have tried using your code but when I do I receive a Run Time Error '424'.

I also tried running via the userform & selecting one of the option buttons but I still receive the same error highlight the line 'If OptionButton1.Value = True Then'. Can you see anything else I may require in the code?

[Norie]

Where is the code located and what is the error message?