View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default 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