Drop Down Box
 

Does anyone know how i can provide a drop down box for cell population
rather then manually trypin the information into each cell?
Thanks
James


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=389018

Good afternoon themax16

Why not use the Data Validation function, in the Allow box select
List, and then type your list of possible values into the Source box,
or highlight a range of cells containing allowed values.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389018

Look on Debra's site for Data Validation
http://www.contextures.com/xlDataVal01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"themax16" wrote in message
...

Does anyone know how i can provide a drop down box for cell population
rather then manually trypin the information into each cell?
Thanks
James


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=389018

Thanks very much for your help.


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=389018

Do you know if this process will exclude the cells from an autofilter?
I have a colum of drop down menus that i wanted to auto filter. this
does not seem to be working..
Can You help??
James


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=389018

Hi James

Seems to be working OK for me using XL2000. Try again. If you are
still struggling post back and I'll upload an example. I know it may
be stating the obvious, but there isn't a blank row between your
heading and the first row of your data is there...?

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389018

It seems that sometimes the simple answer is the correct one.... i did
have a line spacing it.
Many thanks


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=389018

DominicB,

Do you know if it is possible to change any characteristics of a drop down
list created using data validation, eg width of list, or font size? I am
using text aligned at 90°, so not much width for drop down list...
--
Regards,
Jay


"dominicb" wrote:


Good afternoon themax16

Why not use the Data Validation function, in the Allow box select
List, and then type your list of possible values into the Source box,
or highlight a range of cells containing allowed values.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389018