Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date and time picker | Setting up and Configuration of Excel | |||
How can I insert a drop down date picker to worksheet cells? | Excel Worksheet Functions | |||
How can I insert a drop down date picker to worksheet cells? | Excel Programming | |||
how I can insert date picker in excell template? | Excel Discussion (Misc queries) | |||
range picker / selector | Excel Programming |