Excel 2007 : how to pass the selected combo box text value from one sheet to another sheet

[suresh mongam]

Hi Frnds,


I am new to excel coding..

i have one doubt (i.e how to pass the selected combo box text value from one sheet to another sheet).

for eg:

In sheet1 i have one combo box in column A (cell A2) i can select one item from the combo box that selected text or value pass to the sheet2 (in sheet2 column A cell A2). same combo box put in cell A3 and select one item that selected value pass to sheet2 in cell A3 and so on....
please help me.

Thanks & Regards
U r frnd.

[davesexcel]

What kind of combo box is this?

[suresh mongam]

Hi daves,


i am new to excel coding...

In excel sheet 2 tabs there. one is field order and second one is masterlist,in sheet "field order" 3 column are there (i.e id,name,size). in column "size" client says put dropdown(in dropdown no.of items are there these items come from masterlist sheet) for predictive option. but i can put Activex combobox because he enter something in "size" column the data must be predictive (eg: he enter something like "2X4" in size column automatically it comes this is predictice u know that) my doubt is i put combobox there are no.of itmes are there that is in column "C".in column C cell c2 he enter size "2X4" it will come from combobox,again cell c3 he enter 2X4X6 it will come from same combobox and so on like that and that selected data (i.e 2X4 in cell c2 that data automatically pass to another sheet in cell c2).predictive optionis must and select data from combobox in cell c2 and pass that data to another sheet in cell c2 automatically.combobox data is must for total no.of cells in column C in field order.

please help me...

Thanks & Regards
U r frnd...