Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
I have a column of values on a form on which I perform the =SUM function.
The result becomes a reference cell for further calculation. I would next like to include a drop-down list that allows me to perform various functions on the reference cell and deliver the result up to a destination cell where the value is called up for further calculation. The list requires three states 1) do nothing, but return a text message indicating a null result, 2) deliver the value of the reference cell to the destination cell, for further processing and, 3) multiply the value of the reference cell by 2 and deliver the value to the destination cell. The drop down list, should provide a degree of self-documentation so that when the form is printed, the process that was employed is clearly recorded. I have been looking at Worksheet_ChangeEvents but I cant understand what I would need to do to make it work in this instance and (because the reference cell is the result of a formula {=SUM(column)}) I am not sure that it is appropriate in this instance anyway. I would really like to learn how to do this myself but I find the whole issue of the coding impenetrable so if anyone can help me I would be immensely grateful. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
Hi DD,
Let's say that the reference cell in your case is D34. In another cell, say D36, enter in NULL, or whatever text you like. In D37 put "=d34" (without the quotes) In D38 put "=d34*2" (without the quotes) In say, E34 place a drop down box and set its cell link to F34 (as your destination cell.) Also set its list range to be "d36:d38". Modify as you need. Let me know if this helps. Squeaky "34DD" wrote: I have a column of values on a form on which I perform the =SUM function. The result becomes a reference cell for further calculation. I would next like to include a drop-down list that allows me to perform various functions on the reference cell and deliver the result up to a destination cell where the value is called up for further calculation. The list requires three states 1) do nothing, but return a text message indicating a null result, 2) deliver the value of the reference cell to the destination cell, for further processing and, 3) multiply the value of the reference cell by 2 and deliver the value to the destination cell. The drop down list, should provide a degree of self-documentation so that when the form is printed, the process that was employed is clearly recorded. I have been looking at Worksheet_ChangeEvents but I cant understand what I would need to do to make it work in this instance and (because the reference cell is the result of a formula {=SUM(column)}) I am not sure that it is appropriate in this instance anyway. I would really like to learn how to do this myself but I find the whole issue of the coding impenetrable so if anyone can help me I would be immensely grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |