MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checkbox shows backcolor when clicked??


Posted by Ron on March 23, 2001 8:26 AM

I have a number of excel sheets with VB checkboxes on them. I'm using a background image for the sheets and have set the backstyle property of the checkboxes to Transparent. However, when these checkboxes are clicked the Backcolor property shows up for the checkbox. We would like to be able to check the boxes without the background of the page changing in the checkbox. Any suggestions?? Thanks.


Posted by Dave Hawley on March 23, 2001 7:34 PM

Hi Ron

I have just had a bit of a play with this and the best I can do is have it go back to transparent when Focus is lost:

Private Sub CheckBox1_LostFocus()
CheckBox1.BackStyle = fmBackStyleOpaque
CheckBox1.BackStyle = fmBackStyleTransparent
End Sub

Dave

OzGrid Business Applications

Posted by Ron on March 26, 2001 5:44 AM

Dave,
Thanks for the suggestion. I gave it a try, but I'm still running into the same problem. I also tried changing the backstyle property on the click event, but it still keeps changing. Thanks again. Ron