Posted to microsoft.public.excel.programming
|
|
insert data picker into range of cells
Maybe this will help
http://www.rondebruin.nl/calendar.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"EdStevens" wrote in message ...
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.
|