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!