VBA to check if checkbox is toggle-on
 

Hi, I am trying to use Excel VBA to block SAP vendor master MK05 by toggle-on
"selected Purchasing organization' checkbox. However, there are some vendor
had already been blocked previously and should skip checkbox activatation.

How do make use of VBA to check if the checkbox is active and then skip ?

VBA to check if checkbox is toggle-on
 

Hi Jeff,

'---------------------
Hi, I am trying to use Excel VBA to block SAP vendor master MK05 by
toggle-on
"selected Purchasing organization' checkbox. However, there are some vendor
had already been blocked previously and should skip checkbox activatation.

How do make use of VBA to check if the checkbox is active and then skip ?
'---------------------

If your question relates to verfying the status of a checkbox, try something
like:

'=============
Private Sub CheckBox1_Click()
If Sheets("Sheet1").CheckBox1.Value = True Then
MsgBox "CheckBox1 Is Checked!"
Else
MsgBox "Not checked"
End If
End Sub
'<<=============

If, however your question relates to the use of other software, perhaps
your question should more properly be addressed elsewhere.


---
Regards,
Norman