set up drop dpwn using VBA
 

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......

set up drop dpwn using VBA
 

Check out Excel's Validation Object.

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

--JP

On Nov 9, 5:28*pm, J. Freed wrote:
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......

set up drop dpwn using VBA
 

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

Sam


"J. Freed" wrote:

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......