Maybe you'll have to modify a solution to get what you want, but you've
been shown how to get each of the values that you have a choice of
(plus a count of text values). Going through the clipboard itself is a
rather "inelegant" solution in itself, because no one but you is going
to know where those values came from.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"J_B_#" wrote ...
Thanks guys.

Paul's solution is near the mark, but lacks choice of function, so would
require several buttons/macros.

David's solution doesn't address the need to drop a single value into the
clipboard.

Obviously one could write a macro to interrogate a combo/list button (not
that I have the skill), but that seems inelegant whilst that value must be
around in the guts of excel somewhere.

John B