| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate a drop down list with commands
Can ANYBODY help me with this please? I am really struggling with it.
I am not sure if this makes any difference but the source cell contains the =SUM formula at the bottom of column of values. It's the sum value I want to process with commands A and B; Command C would signify a not applicable command. I have worked out how to build a list from list validation but I can't get any further... HELP! "sjbegley" wrote: I would like to populate a drop down list with commands. Command A - return the sum of a specified cell Command B - return the sum of a specified cell and double its value (x2) Command C - return "N/A" We only need to specify two cells (the source and the result) but it is the coding and the functions that are unfathomable for me. Please assume I know nothing about VB or VBA - you won't be far wrong! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I populate a drop down list from Data Validation? | Excel Discussion (Misc queries) | |||
| Drop down list - need to reference and populate another cell with | Excel Discussion (Misc queries) | |||
| Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
| validation list drop down box, how do I bring in text commands | Excel Discussion (Misc queries) | |||
| Populate Drop Down List | Excel Worksheet Functions | |||
Linear Mode
