VBA Script to run macros based on the dropdown value

[nathan1986]

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

[macropod]

Aside from the fact your posted code is missing the closing:
End If
End With
End Sub
statements, which I assume it has, your code looks OK. What is the error message and what code line, if any, if highlighted at that time?

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen.