Indicate the presence of a drop-down list

[Sam_Gregson]

Hi guys- quick one....

Does anyone know if it is possible to always display the little arrow which indicates the presence of a drop down list?

At present the arrow is not present unless the cell is selected and users of my workbook/toolkit can easily miss the drop down lists (although i have colour coded them).

Hope you can help,

Cheers,

S

[martindwilson]

you cant
use a combo list from the forms tool bar instead
a useful thing is it generates numbers so you can use choose instead of if
choose(A1,do something,do somthing else,..........)up to 30

[Sam_Gregson]

Thanks very much Martin,

Sam