Permission denied, sometimes, when writing an array to listbox...why?

[khervey]

This line of code sometimes results in a "permission denied", but other times it works fine.

UserForm5.ListBox1 = arrayOutput

Seeking help/ideas/suggestions

 

[Rick Rothstein]

This line of code sometimes results in a "permission denied", but other times it works fine.

UserForm5.ListBox1 = arrayOutput

Seeking help/ideas/suggestions

[Untested] What happens if you try it this way...

UserForm5.ListBox1.List = arrayOutput

 

[khervey]

[Untested] What happens if you try it this way...

UserForm5.ListBox1.List = arrayOutput

Rick,

My apologies to you and all. My actual listbox name is way too long, so I shortened it and accidentally wrote over ".List". Actually, I think without ".List" it would never work.

That is the way that works when it works. The Sub loads up the array then writes to the list box. I can run it over and over again successfully, but then when I do something else in some other sub, it fails. I will dig into the other code, but I can't imagine anything else making the listbox have no permission.

I have tried unload, hide, show and such. I just can't imagine what would case a listbox to deny a permission

 

[Fluff]

Check that you haven't set RowSource anywhere

 

[khervey]

Check that you haven't set RowSource anywhere

I did not know about RowSource (so doubt I used it); I looked it up: https://msdn.microsoft.com/en-us/library/office/ff196460(v=office.14).aspx

 

[RoryA]

As Fluff mentioned, I have only ever seen that happen if you have set the Rowsource to load the control from a range.