insert data picker into range of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EdStevens - 27 May 2008 16:44 GMT

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.

Reply to this Message

Ron de Bruin - 27 May 2008 17:08 GMT

Maybe this will help
http://www.rondebruin.nl/calendar.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>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
[quoted text clipped - 8 lines]
>
> Thanks in advance.

Reply to this Message

Rick Rothstein (MVP - VB) - 27 May 2008 17:27 GMT

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

>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
[quoted text clipped - 11 lines]
>
> Thanks in advance.

Reply to this Message