Excel Validate Cell Drop Down

Scripting Forums AppleScript | Mac OS X
,
#1

Hi, does anyone know about setting cell validation with applescript?

I have a script that generates a new document and populates it but I need to tell Cell A7 to be a drop down list with the values “Yes,No,Don’t know”. I can do it manually but the real trick would be to script this.

I have looked in the reference but I keep getting the message “Cell doesn’t understand the add data validation message”

Any help would be much appreciated.

Mark

#2

Managed to work it out at last so I thought I’d post it here to share.

tell application "Microsoft Excel"
	activate
	tell document 1
		tell sheet 1
			add data validation (validation of range "A1") type validate list formula1 "1,2,3,4"
		end tell
	end tell
end tell