How do I copy the detail from a ComboBox on a UserForm onto a worksheet


On a previous project I had the following code to copy a value from
cell on one worksheet to a a cell on another

'Colleague Initials
Sheets("Call Logging Tool").Range("j8").Copy _
Sheets("Call Statistics").Range("c65536").End(xlUp).Offset(1, 0)

Can this be amended to carry out what I need

--
Message posted from http://www.ExcelForum.com

Try this

Sheets("Sheet1").Range("A1").Value = Combobox1.Value


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alan T " wrote in message ...
How do I copy the detail from a ComboBox on a UserForm onto a worksheet?


On a previous project I had the following code to copy a value from a
cell on one worksheet to a a cell on another

'Colleague Initials
Sheets("Call Logging Tool").Range("j8").Copy _
Sheets("Call Statistics").Range("c65536").End(xlUp).Offset(1, 0)

Can this be amended to carry out what I need?


---
Message posted from http://www.ExcelForum.com/