Hi Zaahir,

Try:

ActiveCell.Value = Me.ComboBox1.Value

or

ActiveCell.Value = frmNewEntry.ComboBox1.Value


---
Regards,
Norman


"Zaahir" wrote in message
...
Happy New Year Evry1
Hi

I have a combobox on a userform in workbook1 and need to transfer the
selected info to a cell on workbook2.

ActiveCell.FormulaR1C1 = Workbooks("CISCO
Base.xls").Application.frmNewEntry.ComboBox1.Text

this is the code i've written , how do i alter this for it to actualy wrk?

regards