[AccessD] OT: Excel combo Box Q

Manual user entry into the cell(s) will trigger the validation. Copy paste
or drag and copy unfortunately doesn't trigger the validation so incorrect
data can still be entered. Drag and drop can me turned off by
<tools><options><edit>click check mark on "allow cell drag and drop". This
must be set for each copy of Excel (ie it doesn't follow the worksheet) so I
usually set it off and on in code. 
Jim Hale

-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com]
Sent: Wednesday, April 19, 2006 10:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [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


***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.