MrExcel Publishing
Your One Stop for Excel Tips & Solutions

List Box Format


Posted by Bill Mahoney on January 24, 2002 6:47 AM

Hello, I have a group of cells that when you click the cell you get a drop list of selections. My problem is that when you first click the down arrow to see the list it shows the bottom two entries and like 6 blank rows. So the user would need to move the scroll bar up to see the beggining of the list. My question is: is there a way that i can format the box so when they click the arrow to open the box they see the first entry instead of the last. Thanks for the help.

Bill Mahoney
The Alcott Group


Posted by Steve Hartman on January 24, 2002 7:13 AM


Change the range of the data validation so it doesn't include the blanks. When a data validation list is opened it goes to the entry for whatever is in the cell at the time. since the cell is blank it is going to the first blank line in the list.

Posted by Bill Mahoney on January 24, 2002 7:52 AM

Thanks for the help.

Posted by Steve Hartman on January 24, 2002 7:54 AM

I should have said:

When a data validation list is opened it goes to the entry for whatever is in the cell at the time if it exists in the validation list.