Userform-Database ListCount Permission Denied

[cmxulb]

Hi,
Im trying to auto scroll to the bottom after an input, but I'm getting the error ""Permission Denied"

Private Sub UserForm_Activate()

lstDatabase.AddItem lstDatabase
lstDatabase.ListIndex = lstDatabase.ListCount - 1


End Sub

 

[Domenic]

I don't know why you're getting a "Permission Denied" error, but the following line should give you a "Type mis-match" error..

lstDatabase.AddItem lstDatabase

That's because you cannot add a listbox to a listbox.

 

[cmxulb]

permission denied

 

[Domenic]

The error indicates that you're referring to a folder for which you do not have access privileges. So you must have some other line of code that is causing the error. When the error occurs and the dialog box is displayed, click on Debug. Which line of code is highlighted?

 

[cmxulb]

This code take me to this line
lstDatabase.ListIndex = lstDatabase.ListCount - 1

and if I add this 2nd code
lstDatabase.AddItem lstDatabase .it says "Pemission denied"

 

[Domenic]

When I try running your code, it gives me a type mis-match error, and it highlights this line...

lstDatabase.AddItem lstDatabase

As I have already mentioned, you cannot add a listbox to your listbox. What is it you're trying to do?