Drop down box problem

Please can someone help me!!! I am trying to inset a drop down box int
an excel spreadsheet but haven't got a clue whether I use a list box o
a combo box. I want it to display first, second, third, fourth in th
drop down menu so that the user can sleect one of these. The thing is
don't know how to put the values in the box! Your help would be muc
appreciated! :-

--
Message posted from http://www.ExcelForum.com

JulieD
Thu Aug 26 09:36:09 CDT 2004

Hi

use the Data / Validation - List option ...
click in the cell where you want the drop down, choose Data / Validation
from the menu, choose List, and in the source line type
first, second, third, fourth
click the Ok button

check out www.contextures.com/tiptech.html for more details on how Data
Validation works and different ways to use it.

Cheers
JulieD

"_nic_v >" <<nic_v.1bllco@excelforum-nospam.com> wrote in message
news:nic_v.1bllco@excelforum-nospam.com...
> Please can someone help me!!! I am trying to inset a drop down box into
> an excel spreadsheet but haven't got a clue whether I use a list box or
> a combo box. I want it to display first, second, third, fourth in the
> drop down menu so that the user can sleect one of these. The thing is I
> don't know how to put the values in the box! Your help would be much
> appreciated! :-)
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

RagDyeR
Thu Aug 26 09:48:43 CDT 2004

You can use Data Validation.

Easily understood directions can be found on Debra Dalgleish's web page at:

http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"_nic_v >" <<nic_v.1bllco@excelforum-nospam.com> wrote in message
news:nic_v.1bllco@excelforum-nospam.com...
Please can someone help me!!! I am trying to inset a drop down box into
an excel spreadsheet but haven't got a clue whether I use a list box or
a combo box. I want it to display first, second, third, fourth in the
drop down menu so that the user can sleect one of these. The thing is I
don't know how to put the values in the box! Your help would be much
appreciated! :-)


---
Message posted from http://www.ExcelForum.com/