| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down/List w/Code and Definition, only code entered when selec
What do I create if I want to display a list of codes and definitions, but
only want the code to be entered in the cell when selected? Displayed: MX Mexico US United States When selected, only MX or US should be entered in the cell |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down/List w/Code and Definition, only code entered when selec
One play to achieve it here would be
to use a combo box from the control toolbox toolbar Try this sample from my archives which illustrates: http://savefile.com/files/221672 Combo box from control toolbox toolbar_Example2.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Spiritdancer" wrote: What do I create if I want to display a list of codes and definitions, but only want the code to be entered in the cell when selected? Displayed: MX Mexico US United States When selected, only MX or US should be entered in the cell |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down/List w/Code and Definition, only code entered whenselec
You can do this with data validation and programming. There's a sample
file he http://www.contextures.com/excelfiles.html Under Data Validation, look for DV0005 - Data Validation "Columns" Spiritdancer wrote: What do I create if I want to display a list of codes and definitions, but only want the code to be entered in the cell when selected? Displayed: MX Mexico US United States When selected, only MX or US should be entered in the cell -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to delete sheets not in use based on a cell's drop down list | Excel Worksheet Functions | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Worksheet Functions | |||
| VBA Range definition: Code needed | Excel Discussion (Misc queries) | |||
| Code to an in cell drop down list | Excel Discussion (Misc queries) | |||
| How do I color code items in a drop down list? | Excel Discussion (Misc queries) | |||
Hybrid Mode
