Windows XP increse the drop down list size ?

A

abhikop

Joined
Jul 19, 2008
Messages
1
Reaction score
0
"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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restrict Choice in Shared WB (drop down alternative)? 0
Filtered drop down list 2
Drop down list from index/match formula 1
How to enter start and end date/time in excel based on some specific value. 7
Drop Down List Quicker Selection 4
Drop down list 2
Excel VBA Excel Macro to call drop down Validation List 12
drop down list 1

Top