How to enlarge Data Validation List window

[z168]

I have this data validation list with TIME

how do I make it longer to show the whole list instead of having to scroll through the whole 8hours

 

[CWatts]

You can't extend the lines with data validation.

To do that you need to use a combo box where you can select the number of objects to display in the list.

 

[z168]

You can't extend the lines with data validation.

To do that you need to use a combo box where you can select the number of objects to display in the list.

How do I do that? care to expound on that?

 

[Andrew Poulsom]

Look here:

http://www.contextures.com/xlDataVal10.html

 

[z168]

Look here:

http://www.contextures.com/xlDataVal10.html

Thanks for the replies. But I tried the link and I couldnt understand how to make the code fit what I need.

I understand data validation, but unfortunately I cant make the combo box work

 

[Andrew Poulsom]

The instructions in the link I gave you are very clear. What didn't you understand?

 

[z168]

The instructions in the link I gave you are very clear. What didn't you understand?

Hi Andrew, thanks for responding.

I am able to make the example in the link work. However when I try to do it again for what I need in my spreadsheet it doesnt work. I tried it 10 different times.

Is there something in the VBA code that I need to change to make it go specifically to the cell I need it to be?

Im making the rowlist from 8 to 30, was the 30 throwing it off?


here is the example working

 

[Andrew Poulsom]

The DoubleClick procedure tests if the cell has validation with a list, and if so shows the ComboBox. So everything should happen automatically.

 

[z168]

The DoubleClick procedure tests if the cell has validation with a list, and if so shows the ComboBox. So everything should happen automatically.

Thanks Andrew. I will try it again maybe my head wasnt screwed in right yesterday.

TGIF