View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jweasl jweasl is offline
external usenet poster
 
Posts: 29
Default Referencing check box names in VBE

My checkbox's NAME value is EndCaps
By default it's ENABLED value is set to false. When i load my userform, if
cell b70, i want the enabled value to switch to true.
Here's what I've been trying.... don't laugh, i'm still new :-P
GutterOptions is my userform

Sub FabGutterMain()
If Range("B7").Value 0 Then EndCaps.Enabled = True
GutterOptions.Show

it keeps giving me an error saying "Object Required".
Help!