Denis,

Also, I should have pointed out (although it is included in my comments in
the function) that you need to set a reference to "Microsoft Forms 2.0 Object
Library".
Do this by opening the visual basic editor, then goto <Tools then
<References then check the appropriate box.

HTH/

"Denis Petrov" wrote:

Dear VBA gurus

I have data
11111, abc, xxx,
22222, def, yyy
33333, ghi, zzz

I need to create a VBA code to copy vlaue
11111|22222|33333 (yes, that exact format with |) to the cache so user can
Paste, please HELP!!!!

Thanks to all