if then statement in excel

[ironj32]

I have a set of check boxes in excel one of them being "chkOther". when this is true i want the cursor to go to a text boxt "txtVendorPerfOther" and I want to make it required. If it's not true then i would like for txtVendorPerfOther to be locked.
here is what i have so far...

Private Sub chkVendorPerfOther()
If chkVendorPerfOther Is True Then
txtVendorPerfOther ????
???
End If
End Sub

thanks for any help!

 

[jrbarnett]

Something like:

Private Sub chkOther_Click()

  If chkOther = True Then
    ' Ticked
    txtVendorPerfOther.SetFocus
  Else
    ' Not ticked
    txtVendorPerfOther.Enabled = False
    txtVendorPerfOther = ""
  End If

End Sub

 

[ironj32]

this code does not seem to do anything...?

Private Sub chkVendorPerfOther_Click()

  If chkVendorPerfOther = True Then
    ' Ticked
    txtVendorPerfOther.SetFocus
  Else
    ' Not ticked
    txtVendorPerfOther.Enabled = False
    txtVendorPerfOther = ""
  End If

End Sub

 

[ironj32]

i should note that the check boxes i am using are from the Form tool bar...does it make a difference if it is a Form object or a Control object?

 

[ironj32]

......aaannnnnd it does! things might be a little easier now. at this point you can all ignore my posts in this thread. thanks!