View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
SplatterKat SplatterKat is offline
external usenet poster
 
Posts: 7
Default Runtime error with vba and checkbox


Dave Peterson wrote:
I thought you used the checkbox from the control toolbox toolbar and placed it
on a worksheet.

If you did, then this code is under the worksheet that holds that checkbox. And
the Me. refers to that worksheet.

If you used a checkbox from the Forms toolbar, try changing all the "Me."'s to
"Activesheet." (include the trailing dot).


Ok, I changed them out and am still getting an error.
Object doesn't support this property or method
with the following line highlighted:

myRng.Locked = ActiveSheet.CheckBox1.Value

I do apprecioate the help you have given.

-Robert Lizak-