[AccessD] OT: Excel combo Box Q

DWUTKA at marlow.com DWUTKA at marlow.com
Wed Apr 19 09:56:07 CDT 2006


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



More information about the AccessD mailing list