Create a drop-down list from a range of cells
 

hi, is it possible for a MS-Excel 2000 to Create a drop-down list from a
range of cells? how?


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=554471

Create a drop-down list from a range of cells
 

You can set the .ListFillRange of a combo box.

NickHK

"tweety127" wrote
in message ...

hi, is it possible for a MS-Excel 2000 to Create a drop-down list from a
range of cells? how?


--
tweety127
------------------------------------------------------------------------
tweety127's Profile:
http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=554471

Create a drop-down list from a range of cells
 

Hi
In Excel look up Validation in the Help. In the list of topics you
should see "Create a drop -down list from a range of cells". This might
be what you want.
regards
Paul

tweety127 wrote:
hi, is it possible for a MS-Excel 2000 to Create a drop-down list from a
range of cells? how?


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=554471