VBA Editing Problem

I have this code:

Please Login or Register  to view this content.

It is a simple dynamic conversion tool. Whereas in Excel, we usually have one input cell and one output cell. Through this code, both input cells are also output cells. I.E. Converting Dollar to Peso or Peso to Dollar, Meter to Inches or Inches to Meter....

Problem is, this code only specifies two specific cells, namely b9 and c9 with b13 as the conversion factor. How can I expand the code to include multiple pairs of cells. I.E. A1:B1, C10:C11,etc by 1) Using the same 'conversion factor' cell (b13) and 2) Using different conversion factors located in different cells on the worksheet.

Many thanks,

lex

Originally Posted by FrankBoston

Store the locations of conversion locations (B9, C9) and the related rate locations (B13) in a string array. Loop through the array to identify changed cells of interest and get the rate from the associated location.
For further efficiency, this array can be declared globally and filled with data on the Worksheet_Open event.

Please Login or Register  to view this content.

Thanks for the reply FrankBoston.

However, I'm not really that much knowledgeable in VBA. Do I jut copy this code and paste it?

I plan on doing several pairs of cells to refer to the same conversion factor (b13). How do I do it?

Many thanks,

lex