VBA to check if checkbox is toggle-on

G

Guest

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 ?
 
N

Norman Jones

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.
 

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

Top