Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
How to multipile Combox 1 & Combox 2.
Any one can help me. Thanks JOHN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
Your question isn't very clear. Try
Dim Result As Double Result = CDbl(ComboBox1.Value)*CDbl(ComboBox2.Value) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John" wrote in message ... How to multipile Combox 1 & Combox 2. Any one can help me. Thanks JOHN |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
Hi Chip
Thanks for your reply, my question is I prepare excel sheet 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 "John" wrote: How to multipile Combox 1 & Combox 2. Any one can help me. Thanks JOHN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to populate worksheet from 2 combo boxes | Excel Worksheet Functions | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |