Remove Vertical Scroll Bar In Data Validation List

Hi,

Is there a way to eliminate the vertical scroll bar in a List (created using Validation item under Data) so users can see all of the items listed without having to use their mouse to scroll down?

Trying to save time and minimal use of mouse.

Thank you for help

Hi,

Unfortunately, List created by Data Validation is pretty limited.

You can use a List Box or Combo Box under Developer Controls. Those can be sized to fit the list of data you have so that there won't be a scroll option.

Hope this helps

BUMMER....thanks southward