View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff[_5_] Geoff[_5_] is offline
external usenet poster
 
Posts: 17
Default Only run if check box is checked

I have some code that I only want to be run if a check box is checked. So I
inserted an ActiveX check box which I have named cbRecord.

I then put the following IF around the code which is initiated by clicking a
spinner form control:

If cbRecord.Value Then
....
....
....
End If

However, when the code is run I get the following error: Run time error
'424': Object required. When I go to debug, the code doesn't even know that
my check box exists.

TIA...Geoff