ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Permission Denied (https://www.excelbanter.com/excel-programming/278433-permission-denied.html)

Audrey Ng

Permission Denied
 

Hi everyone,

I have a listbox and I want to add an item to this listbox based on what
the user enters in the InputBox. I'm getting a permission denied error.
Any ideas? Here's my code:

Private Sub CommandButton5_Click()

StudyInput = InputBox("Please enter the new study")
ListBox1.AddItem StudyInput

End Sub




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Bill Li

Permission Denied
 
Maybe you forget the userform name

Userform1.ListBox1.AddItem StudyInput

Best Regards

Bill
-----Original Message-----

Hi everyone,

I have a listbox and I want to add an item to this

listbox based on what
the user enters in the InputBox. I'm getting a permission

denied error.
Any ideas? Here's my code:

Private Sub CommandButton5_Click()

StudyInput = InputBox("Please enter the new study")
ListBox1.AddItem StudyInput

End Sub




*** Sent via Developersdex http://www.developersdex.com

***
Don't just participate in USENET...get rewarded for it!
.



All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com