Checkbox background pattern problem

J

jsa1981

I have put a checkbox from the Control toolbox onto my page.

I want to empty, lock, and grey out a cell if the checkbox is NOT
checked.
I have done the emptying, and the locking, but I need help with the
greying out.
What I need is not a simple colour, but a pattern. Secifically, when
using Excel 2000, I need the following color:
Go to format, cells.
Go to the patterns tab.
In the Pattern dropdownlist, I want the bottom-right pattern (light
diagonal crosses). I also want the lightest shade of grey from the same
dropdownlist.

Can anyone help me find how I can do this? Here is my code so far.

Private Sub CheckBox1_Click()
CheckBox4.Value = False
CheckBox5.Value = False
CheckBox6.Value = False

If CheckBox1.Value Then
CheckBox4.Enabled = True
CheckBox5.Enabled = True
CheckBox6.Enabled = True

Range("L61:T61").Value = ""
Range("L61:T61").Locked = False
Else
CheckBox4.Enabled = False
CheckBox5.Enabled = False
CheckBox6.Enabled = False

Range("L61:T61").Value = ""
Range("L61:T61").Locked = True
Range("L61:T61").Interior.Pattern = ""
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check Boxes question 5
Adding controls to userform 3
Is there an easier way of doing this?? 0
Click event for checkbox from Forms toolbar 6
Checkbox problem 5
Hidden rows appearing on open 2
excell error on close with commandbutton 2
Check box blues 1

Top