userforms & workbooks
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
|