Darren DICK
darrend at nimble.com.au
Wed Apr 19 18:54:38 CDT 2006
Hi Drew, Jim Hewson and Jim Hale Thanks Validation was the answer Thanks for the other tips Brilliant Darren ------------------------------ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, 20 April 2006 12:56 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] OT: Excel combo Box Q To do this for one cell, select the cell, for a whole column, select the column. Once selected, go to Data --> Validation. That will open a form. On the first tab, change the combo box to 'list'. You can set up the list any way you want, the easiest is to make it another column (say on a background sheet). Now the users will get a combobox when they are in that cell/column, and it will force them to select from the list. You can even customize the message they get if they try to put different data in, with the Validation option. Drew -----Original Message----- From: Darren DICK [mailto:darrend at nimble.com.au] Sent: Tuesday, April 18, 2006 8:09 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] OT: Excel combo Box Q Hi All OT - EXCEL Q We have an excel spreadsheet I want to limit the data entry for 5 or 6 columns to the data in combo boxes for a whole column firstly - How does one create a combo in Excel and 'bind' its results to a cell? Secondly - Do I have to manually do this for each cell in the column? (Potentially 5 or 6 X 65K ?) Many thanks Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com