Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - combination of values
Greetings. I would like to validate the data entered into a group of cells.
I would like the input limited to the following values and/or combination thereof: Cvg, Liab, Dmgs, Dispo (I am looking to avoid creating a list or range containing each possible combination: Cvg, Liab / Cvg, Liab, Dmgs / etc). Is this possible? Any suggestions? Many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - combination of values
Suzanne
It's not clear what you want. You say you want DV in a group of cells. What list do you want in the first DV cell? What list do you want in the second DV cell? And so forth. Maybe you want the list in the second cell to be dependent on the choice made in the first cell? If so, what do you want in the third cell? And so forth. Some examples would be nice too. HTH Otto "Suzanne" wrote in message ... Greetings. I would like to validate the data entered into a group of cells. I would like the input limited to the following values and/or combination thereof: Cvg, Liab, Dmgs, Dispo (I am looking to avoid creating a list or range containing each possible combination: Cvg, Liab / Cvg, Liab, Dmgs / etc). Is this possible? Any suggestions? Many thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - combination of values
Thank you for your response. So sorry i wasn't clear : ( I found a posting
that referred me to site: http://www.contextures.com/excelfiles.html DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. This illustrates excacly what i'd like to do, the CommaSeparated tab. When i attempt to copy the vb script into my workbook and replace my list of variables (dvs), name range, etc. Nothing happens. In short, i'd like the user to be able to selelect multiple items from a dv list, without the list containing all variations/combinations of each. I appreciate your help, hope you can. Thank you. - Suzanne. "Otto Moehrbach" wrote: Suzanne It's not clear what you want. You say you want DV in a group of cells. What list do you want in the first DV cell? What list do you want in the second DV cell? And so forth. Maybe you want the list in the second cell to be dependent on the choice made in the first cell? If so, what do you want in the third cell? And so forth. Some examples would be nice too. HTH Otto "Suzanne" wrote in message ... Greetings. I would like to validate the data entered into a group of cells. I would like the input limited to the following values and/or combination thereof: Cvg, Liab, Dmgs, Dispo (I am looking to avoid creating a list or range containing each possible combination: Cvg, Liab / Cvg, Liab, Dmgs / etc). Is this possible? Any suggestions? Many thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - combination of values
Do you have macros enabled? ToolsMacroSecurity
If you set security to Medium, you'll be asked if you want to enable macros when the workbook opens. Suzanne wrote: Thank you for your response. So sorry i wasn't clear : ( I found a posting that referred me to site: http://www.contextures.com/excelfiles.html DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. This illustrates excacly what i'd like to do, the CommaSeparated tab. When i attempt to copy the vb script into my workbook and replace my list of variables (dvs), name range, etc. Nothing happens. In short, i'd like the user to be able to selelect multiple items from a dv list, without the list containing all variations/combinations of each. I appreciate your help, hope you can. Thank you. - Suzanne. "Otto Moehrbach" wrote: Suzanne It's not clear what you want. You say you want DV in a group of cells. What list do you want in the first DV cell? What list do you want in the second DV cell? And so forth. Maybe you want the list in the second cell to be dependent on the choice made in the first cell? If so, what do you want in the third cell? And so forth. Some examples would be nice too. HTH Otto "Suzanne" wrote in message ... Greetings. I would like to validate the data entered into a group of cells. I would like the input limited to the following values and/or combination thereof: Cvg, Liab, Dmgs, Dispo (I am looking to avoid creating a list or range containing each possible combination: Cvg, Liab / Cvg, Liab, Dmgs / etc). Is this possible? Any suggestions? Many thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |