Combo Box

C

Chip Pearson

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
 
J

John

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
 
Top