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