cell, choose from a list

[SS]

Ok I have 2 questions and not sure if they will have the same answers.

I have 2 cells in excel worksheet, it is a booking form.

In the first cell thay have to put their arrival time, when they click on
this it states please use 24 hour clock, I have done this but cant remember
how to do it as it was way back last year.


In another cell they have to type in the departure airport, I want to create
a drop down list that they can choose from, how do I do this?


thanks

 

[Dave Peterson]

I think you could use Data|Validation (in xl2003 menus) for both.

Select the time cell
Data|validation
Settings Tab|In the Allow dropdown, choose Time and between the starting and
ending times you want.

Then on the input message tab, type the message you want the user to see when
they select the cell.

Personally, I'd let them enter the time anyway they want, but format the cell
that it shows hh:mm:ss (that 24 hour time format).

The airport cell can use the same thing.

Debra Dalgleish has some very nice instructions here:
http://contextures.com/xlDataVal01.html

 

[SS]

Thank you for your help and quick response.

I think you could use Data|Validation (in xl2003 menus) for both.

Select the time cell
Data|validation
Settings Tab|In the Allow dropdown, choose Time and between the starting
and
ending times you want.

Then on the input message tab, type the message you want the user to see
when
they select the cell.

Personally, I'd let them enter the time anyway they want, but format the
cell
that it shows hh:mm:ss (that 24 hour time format).

The airport cell can use the same thing.

Debra Dalgleish has some very nice instructions here:
http://contextures.com/xlDataVal01.html