Hi there..
I'm a Civil Engineer and I've written a code for Calculating the rate
of various Items or work.
I've designed 20 ComboBox and assigned same Cell Range to all th
Comboboxes. The code written for a CommandButton which picks variou
types of rates and material requirements depending on the Specificatio
of the Item of the corresponding ComboBox. For ex. for the combobox
I've assigned C8 as linked Cell and in the code I've assigned C8 fo
performing the calculations.
(For example,
r = Worksheets("Links").Range("c8").Value + 2
Worksheets("Links").Range("a10")
Worksheets("Lead").Cells(rwindex, colindex).Value
ActiveCell.Value
Worksheets("Links").Range("a10")

For second ComboBox ie., ComboBox2 If I assign C9 as the LinkedCell th
Code I've written for the ComboBox will not work. The Code is same fo
all the ComboBox except the LinkedCell will chane as per the 2
ComboBoxes. Please anybody tell me how to assign linkedCell of the 2
Combobox to a same Subroutine and perform the calculations.
shash

--
shashidharg
-----------------------------------------------------------------------
shashidharga's Profile: http://www.excelforum.com/member.php...fo&userid=1492
View this thread: http://www.excelforum.com/showthread.php?threadid=26580