| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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...... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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...... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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...... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| controlling a form drop down based on selection of another drop down | Excel Programming | |||
| drop dpwn tables in excel | New Users to Excel | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Linear Mode
