Solved

Spreadsheet 10.0 Componenet / VBA / List Validation

Posted on 2004-04-01
1
528 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Outlook Free & Paid Tools
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now