combo box versus list box

not very bright dave

Board Regular
Joined
Dec 20, 2004
Messages
244
Hi

I'm probably being a bit dumb but all the examples I've come accross seem to utilise a combo box as a posistion (as in value) locator for one column of data. Is this correct? I thought you could use it to enter and return data.

Thanks

Dave
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Hi Dave, both a ListBox and ComboBox are controls to store a list of values to enable you to select from a pre-chosen list of options. The benefits of these are that it enables consistent results to be returned (ie avoids mis-spelling and invalid options). What you do when an option is chosen from the list is up to you. Sometimes nothing happens, its just there to display an option and other times actions occur such as placing the value into a cell etc.

ListBoxes having nothing to do with columns per se. They are more like rows of data.

If your wanting to enter data this is normally achieved via a TextBox control. There are quite a few different controls available, simply because of the variety of things you may wish to do.
 

Forum statistics

Threads
1,181,791
Messages
5,932,066
Members
436,817
Latest member
Fatoux

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top