Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
Hi
I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
in D1:
=C1*INDIRECT("B" & F1) You have F1 as link cell in both cases ...is this correct? HTH "John" wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
I don't think you should use two comboboxes. The second one should never be
used--it'll only be displayed to the user. In fact, I think it would be much easier to drop the comboboxes and use Data|Validation for just the cells that will contain the item name. Then use a formula in column B: =if(a1="","",vlookup(sheet2!a:b,2,false)) and in d1: =if(a1="","",b1*c1) You can find lots of tips for Data|Validation at Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html John wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
Yes F1 as link cell, I try to type in = C1*INDIRECT("B" & F1) but dosen't
work. I would like to send the excel attach file to let you see than you may give better advice. If possible could give your e-mail address and your help would be greatly appreciated. JOHN "Toppers" wrote: in D1: =C1*INDIRECT("B" & F1) You have F1 as link cell in both cases ...is this correct? HTH "John" wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
Thanks Dave, but I would like to send my excel worksheet to you and you could
give better advice. If possible, may i have your e-mail address and i will send the attached file for your information. Yours kind advice would be appreciated. JOHN "Dave Peterson" wrote: I don't think you should use two comboboxes. The second one should never be used--it'll only be displayed to the user. In fact, I think it would be much easier to drop the comboboxes and use Data|Validation for just the cells that will contain the item name. Then use a formula in column B: =if(a1="","",vlookup(sheet2!a:b,2,false)) and in d1: =if(a1="","",b1*c1) You can find lots of tips for Data|Validation at Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html John wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
Hi Dave
I go in to your web and found out what I want it, anyway thanks alot for your information. JOHN "Dave Peterson" wrote: I don't think you should use two comboboxes. The second one should never be used--it'll only be displayed to the user. In fact, I think it would be much easier to drop the comboboxes and use Data|Validation for just the cells that will contain the item name. Then use a formula in column B: =if(a1="","",vlookup(sheet2!a:b,2,false)) and in d1: =if(a1="","",b1*c1) You can find lots of tips for Data|Validation at Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html John wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
COMBO BOX CALCULATION !
Glad you found what you needed at Debra's site.
But I've found it best to just post followups directly to the newsgroups. There are lots and lots of people who can answer your question--and you won't have to wait for me to read my email. John wrote: Hi Dave I go in to your web and found out what I want it, anyway thanks alot for your information. JOHN "Dave Peterson" wrote: I don't think you should use two comboboxes. The second one should never be used--it'll only be displayed to the user. In fact, I think it would be much easier to drop the comboboxes and use Data|Validation for just the cells that will contain the item name. Then use a formula in column B: =if(a1="","",vlookup(sheet2!a:b,2,false)) and in d1: =if(a1="","",b1*c1) You can find lots of tips for Data|Validation at Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html John wrote: Hi I need some one help..... Colum 1: Item Name Colum 2: Price List A1 B1 A2 B2 A3 B3 so on...... I insert 2 combo boxes. Box 1 (property, input range A1........A20) cell link F1 Box 2 (property, input range B1........B20) cell link F1 I open box 1 (A1) than box 2 automatically appear (B1) (price) I will put number in C1 than I would like to get answer [box 2 price (B1) * C1] in D1. I hope you will clear my answer, kindly reply my answer ASAP. Yours kindness would be appreciated. Many thanks JOHN -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |