insert data picker into range of cells

  • Thread starter Thread starter EdStevens
  • Start date Start date
E

EdStevens

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date & Time Picker Control 6.0 2
How can I insert a drop down date picker to worksheet cells? 1
Date and Time Picker 4
VBA - retrieve data on last create named range from previous inserted named range 0
Date & Time Picker Control 6.0 - another challenge (for me) 4
VBA Insert Into Specific Cell 0
Cant set the date into a Date & Time Picker from Cell value 5
Date Time Picker : Error 35788 1

Back
Top