Drop down box problem

  • Thread starter Thread starter _nic_v
  • Start date Start date
N

_nic_v

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! :-
 
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
 
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!
==============================================


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! :-)
 
Back
Top