View Single Post
 
Old 05-13-2014, 11:12 PM
nathan1986 nathan1986 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2014
Posts: 1
nathan1986 is on a distinguished road
Default 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
Reply With Quote