ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userforms & workbooks (https://www.excelbanter.com/excel-programming/380383-re-userforms-workbooks.html)

Bob Phillips

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






All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com