I need to copy numbers from many cells from a excel sheet to a checklist box. I have tried many codes, but it will only copy from the first cell, even if I write ex. A1:A10. It still only copy the A1??? Can any body help me. I really appriciate if you can help me how to do, maybe given me an exsample. 

Hi, you've posted in the forum for MS Visio, but your question seems unrelated to Visio.
Perhaps try one of these forums instead?

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

http://social.msdn.microsoft.com/Forums/en-US/home?forum=vbgeneral

Here's a really great post written by one of the excel MVPs

http://www.siddharthrout.com/vb-dot-net-and-excel/

al