?
Solved

Spreadsheet 10.0 Componenet / VBA / List Validation

Posted on 2004-04-01
1
Medium Priority
?
553 Views
Last Modified: 2007-12-19
Using VBA with MS Excel you can select a row and then set it to use a range for list style validation (restricting the list to the values in the range) allowing for a dropdown style box.  

MS Excel also supports autofill on previously entered text.  I heard you could prefill the column in question with the range you are confining the dropdown cell to and then delete the items in question to have something simalar to and access dropdown (autofill / hinting).

Can list validation be assigned to a Spreadsheet 10.0 control.  Can a autofil list be populated for the control?

I am using the control in an access form to pipe out information into a spreadsheet for easier updating / addition.  Yes I got tired of the funny little boxes and want to use a spreadsheet to type in my data.  

As far as to the why not just use Excel?  I don't want to hassle with the import and export to get a quick manipulation done.  

Anyway thanks ahead,
Geoffrey
0
Comment
Question by:stfuji
1 Comment
 
LVL 1

Accepted Solution

by:
ChrisMeola earned 2000 total points
ID: 10800200
stfuji,

The spreadsheet 10.0 control, as far as I know, doesn't support the validation method.  As you know, it is a scaled down spreadsheet.

If you are looking to just have a spreadsheet UI, then you might consider using the access form in Datasheet view, in which case you can add a Lookup-> combo box and draw the data via query/sql.

Good luck!
HTH
Chris
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question