VBA Script to run macros based on the dropdown value
Hi
Im trying to run different macros based on individual value in a dropdown field
So basically if the value of the dropdown is accounting then the some check box should be checked
This is the code im using not sure what the error is
Private Sub Dropdown3()
With ActiveDocument
If .FormFields("Dropbox3").Result = "Accounting" Then
.FormFields("Check1").CheckBox.Value = True
.FormFields("Check2").CheckBox.Value = True
.FormFields("Check3").CheckBox.Value = True
.FormFields("Check6").CheckBox.Value = True
.FormFields("Check7").CheckBox.Value = True
.FormFields("Check8").CheckBox.Value = True
.FormFields("Check9").CheckBox.Value = True
.FormFields("Check11").CheckBox.Value = True
|