Cannot manually add items to an Excel Form ListBox control

[Martin SChukrazy]

Hello
I have a user form that just hangs up when i try to manually add items
to a list box control. It works perfectly fine if i point the data source to
be an excel range. So the question is can you or can you not add manually to
a list box control on a user form during initialization ?

Thanks

Martin

 

[Tom Ogilvy]

Manually add items to a listbox control during initialization??? Doesn't
make much sense. What code do you use to manually add items to a listbox
control during initialization? Perhaps you mean use AddItem. There should
be no problem although you need to not have rowsource sent to anything.

 

[Martin SChukrazy]

Sorry i got it. I was pointing it to a datasource and then trying to add
items to list box during initialization which did not work. Once i removed
that it worked fine..

Martin