Windows XP increse the drop down list size ?

[abhikop]

"hello,

thanks for viewing this thread.

i am using office xp excel

i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data

10:00 AM

10:01 AM

10:02 AM

''

''

'

''

5:00 PM

i want to show drop down list box having my own rows to be displayed not current validation's list box's default 8.

you can give me macro to have drop down list which will run when double click or on any key combination.





thanks

abhijeet"