| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data
I need to do the following,
When the user clicks on a cell, it will lanch a small form that contains all of the valid data for the cell, those data are from an Access database. When close the small form, all selected data will be entered into the cell. Is there any way I can do that? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter data
Use Data Validation and pick the list of options from your database.
-- Gary's Student "John" wrote: I need to do the following, When the user clicks on a cell, it will lanch a small form that contains all of the valid data for the cell, those data are from an Access database. When close the small form, all selected data will be entered into the cell. Is there any way I can do that? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Auto enter data from cell above on enter | Excel Programming | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Linear Mode
