Listbox Problems

tready · March 10th, 2006, 08:45 AM

I'm an old VB 6 programmer and I thought we could add single items to list at a time.

list.additem "dummy_value"

How can I recreate this in vba?

peko · March 10th, 2006, 09:03 AM

In Access Listbox: Change Property RowSourceType to ValueList, and it's correct.
In Excel, Word (using MS forms objects): it's the same like VB syntax.

Peko

donrafeal · March 16th, 2006, 03:21 PM

Peko is correct that you need to change the RowSourceType to ValueList, but this only works when using MS Access 2002 or 2003. With MS Access 97 and 2000 the additem method is not available for listboxes and comboboxes.

Don