IF date in cell is not a workday then hide checkbox

What I'm looking for is code for if i enter a date into a cell and this date is either a saturday, sunday or a holiday then checkbox1 is hidden.

Obviously the first part of this is ' Me.CheckBox1.Visible = IIf(Range("$F$6").Value = ' but i can't get the correct code for the last part.

Thanks for any help.

Hello there,

Try this

Please Login or Register  to view this content.

1. Select the worksheet that contains the checkbox
2. Right click on the worksheet's tab
3. Select the View Code option
4. In the space provided, copy and paste the above code I provided. Anything that appears in green is a comment I left to help you understand.
5. Exit out of the Visual Basic Window
6. Change the cell in F6, you should see the checkbox appear and disapear based on the criteria in the code.

Please note: This code assumes that you have an ActiveX checkbox on your worksheet and it's name (different from caption) is Checkbox1.

Just tried it there mate and it doesn't work, doesnt seem to do anything