Disable form Button object if Checkbox not checked

[Zac5]

I have added a form Button object to a worksheet and want it disabled or dimmed until a form Checkbox object also within the worksheet is checked. Please can someone assist with the vba for this. I am guessing the vba to disable the button object would be something like - ???.worksheet("").???.enabled="false" but I haven't found the correct method.

thanks,

Zac

 

[SkipVought]

Zac,

Rather than giving you the answer directly (like giving your a fish) I'm directing you to this FAQ where you can develop a tool to DISCOVER the answer (like teaching you how to fish)

How to use the Watch Window as a Power Programming Tool faq707-4594

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Zac5]

This didn't help

 

[SkipVought]

Each Object on your sheet is a Shape.

Do a watch on Activesheet.Shapes(1)

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}