<div>
<div class="content wysiwyg-content">
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. &nbsp;<br />
<br />
MS Excel also supports autofill on previously entered text. &nbsp;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).<br />
<br />
Can list validation be assigned to a Spreadsheet 10.0 control. &nbsp;Can a autofil list be populated for the control?<br />
<br />
I am using the control in an access form to pipe out information into a spreadsheet for easier updating / addition. &nbsp;Yes I got tired of the funny little boxes and want to use a spreadsheet to type in my data. &nbsp;<br />
<br />
As far as to the why not just use Excel? &nbsp;I don't want to hassle with the import and export to get a quick manipulation done. &nbsp;<br />
<br />
Anyway thanks ahead,<br />
Geoffrey
</div>
</div>


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

Spreadsheet 10.0 Componenet / VBA / List Validation

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.