[AccessD] OT: Excel combo Box Q

One more point to this.  Holding the Ctrl key down while selecting cells, you may select random cells throughout the worksheet.
Keep in mind this is to be used for ONE list of data for all the cells.
Unless, of course, you go to each cell and change it.

Jim 
jhewson at karta.com
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com
Sent: Wednesday, April 19, 2006 9: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