Worksheets and Control Option Buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running Excel 2002. I have a Workbook with 4 worksheets. I created a
Control Option Button (OptBtn01) on Sheet1. I have a Control Check Box
(ChkBx01) on Sheet4. I would like to change Control Check Box (ChkBx01) to
disabled (Enabled = False) whenever the Control Option Button (OptBtn01)
Value is True. Can anyone help?

Thanks in advance.
 
I put this under sheet1:

Option Explicit
Private Sub OptBtn01_Change()
Worksheets("sheet4").OLEObjects("ChkBx01").Enabled _
= CBool(Me.OptBtn01.Value = False)
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Create option group without using wizard? 2
when I protect a worksheet, user cannot use check boxes 4
option button grouping 6
Access Access 2016 button control wizard 2
Can't find hidden worksheet xlsVeryhidden 1
Protected worksheet no longer 2
Search for tabs from a cell value 7
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top