I don't think I'm explaining myself very well. If you copy the values
7,8,9,10 into the clipboard. I want to know how programatically to access
each of the values ie.

Set objCB = New DataObject
objCB.GetFromClipboard
objCB.GetText(1)
objCB.GetText(2)
objCB.GetText(3)
objCB.GetText(4)
Where the 1,2,3,4 are the different slot or elements of the clipboard. I've
read a lot of things that look for text or a specific kind of format that is
on the clipboard, however, I'm interested in being able to reference the
individual elements of the clipboard. It would be the same as seeing the
above values in the clipboard taskpane, and clicking on the 3rd in the list,
or '8' and having that 'paste' into the sheet where ever you choose. As
opposed to clicking the '8', I would like to access that element via vba.

Hopefully this explains more clearly what I'm attempting to do..