insert data picker into range of cells
 

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.

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.

insert data picker into range of cells
 

The reason you are having problems with that code is because you got it from
a Visual Studio 2008 Developer Center webpage. Visual Studio 2008 and, more
specifically, the Visual Basic included within it is part of the .NET
family. VB.NET is not very compatible with VBA. When searching for code
online, stick with code you find for VB5 or VB6, it should have a much, much
better chance of running within VBA than VB.NET code ever will.

As for your request, the link Ron provided should answer your question.

Rick


"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.