View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.