1. Have a look at Data/Validation/List, perhaps that's you are looking for!
2. Pressing Ctrl+: enters current time in the active cell.

Regards,
Stefi

€žBruno€� ezt Ã*rta:

hi there!
I have 2 problems in excel and I count with your help because i don't know
the best way to solve them.

1 - I need to do something like a combobox from where i select one text from
others. How do i do this? Is it possible to do it with lists?

2 - I need a funtion or anything that tells me the precise time hh:mm:ss i
write it and doesn't get updated each time change my file like =now() ? How
do i best do this? (it's to meant to monitor the lenght of phone calls)


Hope you can hel me

Bruno