Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script based on combobox selection
Hi
I have a combobox with various items like 2005, 2006, 2005 Q1, 2005Q2, Business. Combobox is called Combobox1 and in Sheet5 I have a common VB code . ActiveSheet.Evaluate("SUM(IF($CU$7:$CU$4978=2006 ,IF($K$7:$K $4978=""Accept-Create New Project"",$G$7:$G$4978,0),0))") In the above code I have hardcoded it for 2006. But I need to change the 2006 with what ever user selects in combobox. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script based on combobox selection
ActiveSheet.Evaluate("SUM(IF($CU$7:$CU$4978=" & ComboBox1.Value & _
" ,IF($K$7:$K$4978=""Accept-Create New Project"",$G$7:$G$4978,0),0))") -- Charles Chickering "A good example is twice the value of good advice." "gmac" wrote: Hi I have a combobox with various items like 2005, 2006, 2005 Q1, 2005Q2, Business. Combobox is called Combobox1 and in Sheet5 I have a common VB code . ActiveSheet.Evaluate("SUM(IF($CU$7:$CU$4978=2006 ,IF($K$7:$K $4978=""Accept-Create New Project"",$G$7:$G$4978,0),0))") In the above code I have hardcoded it for 2006. But I need to change the 2006 with what ever user selects in combobox. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
change combobox values one by one based on selection in multiselect listbox | Excel Programming | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
Excel - Copy range of cells based on Combobox Selection | Excel Programming |