Thread: VBA Help Required - Copying details from ComboBox onto worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default VBA Help Required - Copying details from ComboBox onto worksheet
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/



Reply With QuoteReply With Quote