I want to stop wrong entries (spellings, capitalised and so on) being input
into a column.
I have set up a data validation drop dpwn list, but this has limited
functionality. I have read (and tried) Debra's page on Combo Boxes, but is
there a direct way of applying a combo box to a column rather than
'piggybacking' it on top of a drop down list? Just seems a bit messy. Also,
what are the differences/advantages of combo boxes over list boxes?
Thanks all
--
Traa Dy Liooar

Jock

While both combo and text box allow you to restrict selections to the
displayed list, text boxes let you set a multi-select property to allow
single selection only or multiple selection, where the user can use the Ctrl
and Shift keys to select/deselect items in the list.

The easiest method or restricting entries is the one that you've already
tried, that being Data Validation. All the other options such as form
controls and forms are going to require a bit more work to get the extended
functionality you need.

--
Kevin Backmann


"Jock" wrote:

I want to stop wrong entries (spellings, capitalised and so on) being input
into a column.
I have set up a data validation drop dpwn list, but this has limited
functionality. I have read (and tried) Debra's page on Combo Boxes, but is
there a direct way of applying a combo box to a column rather than
'piggybacking' it on top of a drop down list? Just seems a bit messy. Also,
what are the differences/advantages of combo boxes over list boxes?
Thanks all
--
Traa Dy Liooar

Jock