Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check/uncheck a checkbox | Excel Programming | |||
check a checkbox in a formula | Excel Worksheet Functions | |||
Checkbox toggle true/false | Excel Programming | |||
Use checkbox to toggle between formula and manual input | Excel Programming | |||
Checkbox value X instead of check | Excel Programming |