Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Spreadsheet 10.0 Componenet / VBA / List Validation

Posted on 2004-04-01
1
Medium Priority
?
548 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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 …

618 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