Difference between AddItem and RowSource

filipegomesfurtado

New Member
Joined
Nov 1, 2016
Messages
1
Hi everyone!

Could someone explain the difference between AddItem and RowSource methods on ComboBox and ListBox form items? Which one it's better to use?

Thanks in advance!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Kyle123

Well-known Member
Joined
Jan 24, 2012
Messages
2,735
Rowsource is for when you want to use a range for the input of a listbox/textbox. It also allows you to use the column headers property of a listbox.

AddItem is for adding any type of data, ie not necessarily from a range. It's generally best avoided for less than about 5 items as it's extremely slow. It's also limited to 10 columns.

Personally, I use neither I use .list. it allows you to populate directly from an array.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,843
Messages
5,766,740
Members
425,377
Latest member
MohdTareq007

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