ActiveCell.FormulaR1C1 = frmNewEntry.ComboBox1.Text


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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