I have a worksheet with 10 cells in which I want a data picker tool. I
thought I should be able to insert it into a selected cell much the same way
I insert a drop-down pick list. But after searching about, it appears that
the only way is to create a vbscript for one-time use. I tried to use the
script at http://msdn.microsoft.com/en-us/library/4za48s1h.aspx, but it gets
a compile error:
"Expected: end of statement", indicated at the equal sign in the DIM
statement.

Ideas?

Thanks in advance.