How can I copy all the contents of a listbox to a clipboard?

I have tried loopping though all the contents of the listbox then using the

VB Code:
  1. DoCmd.RunCommand acCmdCopy

But doesn't seem to copy everything.