set up drop dpwn using VBA

[J. Freed]

I'm building a spreadsheet from within Access/VBA. I export my data into a
spreadsheet template, format some of the cells, unlock others, protect the
sheet then save it with a unique name (and later email it). I'm doing fine up
till this point: using Access/VBA I want to set up some of the cells to only
accept input from a drop down. There will only be 2 allowable values and, as
these worksheets are going to end-users, I'm trying to keep as much of the
complexity as possible within Access.

Any ideas? TIA......

 

[JP]

Check out Excel's Validation Object.

http://msdn.microsoft.com/en-us/library/aa224495(office.11).aspx

--JP

 

[Sam Wilson]

Range("A1").Validation.Add xlValidateList, , , "Option1,Option2"

Sam