Improve company productivity with a Business Account.Sign Up

x
?
Solved

Spreadsheet 10.0 Componenet / VBA / List Validation

Posted on 2004-04-01
1
Medium Priority
?
557 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

606 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