| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Box
I have the list box with the information in it.
When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Box
How did you make the combobox?
Did you use a combobox from the Control toolbox toolbar? Did you use a dropdown from the Forms toolbar? Did you use data|validation? Chey wrote: I have the list box with the information in it. When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Box
Control Tool Box
"Dave Peterson" wrote: How did you make the combobox? Did you use a combobox from the Control toolbox toolbar? Did you use a dropdown from the Forms toolbar? Did you use data|validation? Chey wrote: I have the list box with the information in it. When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Box
Go into design mode.
Show the properties for that combobox Change the LinkedCell property to the address of a cell (out of the way or under the combobox???) then use that linked cell in your formula. =If(a1="Weekly",C20*5,0) (A1 is my linked cell) You need double quotes around strings and you don't need =sum() in your expression. Chey wrote: Control Tool Box "Dave Peterson" wrote: How did you make the combobox? Did you use a combobox from the Control toolbox toolbar? Did you use a dropdown from the Forms toolbar? Did you use data|validation? Chey wrote: I have the list box with the information in it. When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Box
I think I may be a little confused
In my combo box I have the following choices Weekly Every 2 Weeks Twice Monthly Monthly When i linked the cell I linked it to H21 When I choose drop down it changed my cell to Weekly or whatever I choose. Do I put the formula in H21 or in the combo box properties? What I need is Weekly (C20*4.3) Every 2 Weeks (C20*2.15) Twice Montly (C20*2) Monthly (C20*1) Thanks so much for your help Cheyenne "Dave Peterson" wrote: Go into design mode. Show the properties for that combobox Change the LinkedCell property to the address of a cell (out of the way or under the combobox???) then use that linked cell in your formula. =If(a1="Weekly",C20*5,0) (A1 is my linked cell) You need double quotes around strings and you don't need =sum() in your expression. Chey wrote: Control Tool Box "Dave Peterson" wrote: How did you make the combobox? Did you use a combobox from the Control toolbox toolbar? Did you use a dropdown from the Forms toolbar? Did you use data|validation? Chey wrote: I have the list box with the information in it. When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List Box
The linked cell is only going to contain the value of the combobox--not a
formula. So you can use this formula in any other cell (not H21, not C20). =C20*IF(H21="weekly",4.3,IF(H21="every 2 weeks",2.15, IF(H21="twice monthly",2,IF(H21="monthly",1,0)))) (all one cell) And I used "twice monthly" with a difference in spelling. This formula is equivalent: =C20*(((H21="weekly")*4.3)+((H21="every 2 weeks")*2.15) +((H21="twice monthly")*2)+((H21="monthly")*1)) And doesn't use the =if()'s. Chey wrote: I think I may be a little confused In my combo box I have the following choices Weekly Every 2 Weeks Twice Monthly Monthly When i linked the cell I linked it to H21 When I choose drop down it changed my cell to Weekly or whatever I choose. Do I put the formula in H21 or in the combo box properties? What I need is Weekly (C20*4.3) Every 2 Weeks (C20*2.15) Twice Montly (C20*2) Monthly (C20*1) Thanks so much for your help Cheyenne "Dave Peterson" wrote: Go into design mode. Show the properties for that combobox Change the LinkedCell property to the address of a cell (out of the way or under the combobox???) then use that linked cell in your formula. =If(a1="Weekly",C20*5,0) (A1 is my linked cell) You need double quotes around strings and you don't need =sum() in your expression. Chey wrote: Control Tool Box "Dave Peterson" wrote: How did you make the combobox? Did you use a combobox from the Control toolbox toolbar? Did you use a dropdown from the Forms toolbar? Did you use data|validation? Chey wrote: I have the list box with the information in it. When I click on let say Weekly I want a cell in the spreadsheet to If(ComboBox1 = Weekly, Sum(C20*5),0) How do I get this to work? Thanks Chey -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
Linear Mode
