List box or Combo box??

J

Jock

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
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top