Length of a Validation Items drop down choices
 

Hi There,

Using The standard Validation command (Data.. Validation)... within
excel is suiting my purpose just fine, EXCPET I would like to increase
the length of the drop down that is visible.
I have 30 items in the drop down, and it becomes quite tedious scrolling
up and down - the ability to see more would be great... any ideas?

Thanks and Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Length of a Validation Items drop down choices
 

As far as i am aware there is no way to manipulate the standard validation
box.

See http://www.contextures.com/DataValCombobox.xls for an explanation of
using a combo box instead of the default validation box.

HTH

"Darin Kramer" wrote:



Hi There,

Using The standard Validation command (Data.. Validation)... within
excel is suiting my purpose just fine, EXCPET I would like to increase
the length of the drop down that is visible.
I have 30 items in the drop down, and it becomes quite tedious scrolling
up and down - the ability to see more would be great... any ideas?

Thanks and Regards

Darin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!