| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select from list
hi,
i have created an excel spreadsheet that serves as a table (linked) for my access database. i want to prevent users from misentering data so i seek for two things: first i want for each cell in column A users to be allowed to select only from a list that i will create or, if possible from a table in access. second i want to lock the programming of my spreadsheet (functions, list data, etc.) can you help me solve this problem? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select from list
The first part is very easy. You can use a Data Validation drop-down. It
allows users to pick entries from a pre-defined list. see: http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200843 "angie" wrote: hi, i have created an excel spreadsheet that serves as a table (linked) for my access database. i want to prevent users from misentering data so i seek for two things: first i want for each cell in column A users to be allowed to select only from a list that i will create or, if possible from a table in access. second i want to lock the programming of my spreadsheet (functions, list data, etc.) can you help me solve this problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
| Select Dynamic list for rowsource on a list box | Excel Programming | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
| Last list item selected in a Multi-Select list box? | Excel Programming | |||
Linear Mode
